I have a Maria database that is managed by users with a SC project of applications.
I need to send an email once a day that contains alerts regarding some data conditions in the database. I cannot make the email alert system part of the project as users cannot be relied upon to use their application every day. Can I write a script that launches a separate SC project (perhaps a blank application) where that project examines the database and emails out if necessary and then terminates. The script would be launched from a Synology server via a scheduled task. What does the script need to contain in order to launch the SC Project/blankApp ??
Yes, in a cron, you cannot have interactive elements, so you need a blank application.
Thanks for confirming that a blank application is the proper solution - launched from a scheduled task (cron).