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

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

Thanks Roy,
Cheating is always allowed if it gets the job done.
I will have a look at your suggestion.
Regards,
Ian