I had the following problem: I had a job that should run at last December 31th, but the server machine was shut down the friday before. Is there anyway I could be notified that this job didn't run because the machine was shut down?
Thank you!
Hi,
there is no built-in functionality for this, you would have to add an additional step writing to a logging table and check this peridiocally and send out mails (or whatever you want to do for notifications) or send out mails at successfull job execution and monitor this for missing mails (which will indicate the failed execution).
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment