Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Send an email when a Job finishes? |
Wed, Jul 17 2019 6:11 PM | Permanent Link |
Ian Branch | Hi Team,
I have a backup Job that runs on the EDBServer every day at 0430. The Customer has asked if I/it can send an email when the Job finishes. Preferably indicating success or failure. I can't see any way this can happen as it is just SQL running on the EDBServer. Anybody got any contrary thoughts? Regards, Ian |
Thu, Jul 18 2019 3:39 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
>I have a backup Job that runs on the EDBServer every day at 0430. >The Customer has asked if I/it can send an email when the Job finishes. Preferably indicating success or failure. >I can't see any way this can happen as it is just SQL running on the EDBServer. >Anybody got any contrary thoughts? If cheating is allowed you can use ElevateDB's ability to define functions - you'll need to write it in Delphi rather than SQL but so that it can be called as an SQL routine. Then you add a line at the end of your job along the lines of SELECT MyEMailFunction(CURRENT_TIME) FROM sometableorother Roy |
Thu, Jul 18 2019 1:37 PM | Permanent Link |
Ian Branch | Thanks Roy,
Cheating is always allowed if it gets the job done. I will have a look at your suggestion. Regards, Ian |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |