Is it possible to have somesort of trigger activate sending an email based on query while the database is closed (on FM Advanced Server 9)?
I have a table of records with a date field. When the system date is greater than or equal to that date field, trigger an event or script that sends a preformatted, automated email to user(s). There is no guarantee that the database will be open each day.
The automated email is needed also, meaning it shouldn't launch an client email app (Outlook, Eudora etc) then require a user to hit send.