March 9, 2004 at 11:29 am
Hi. Does any one have any suggestions on how I may be notified via email (Example: Mail Session/Operators/xpsmtp) when a SQL Job has failed?
I know about the options available for SQL 6.0 & 7.0 but has any one tried them on SQL 8.0 on MS Win Server 2003?
Thanks,
MG
March 9, 2004 at 12:58 pm
If you have SQL Mail defined click on the notification tab of a JOB properties and indicate you want to be emailed when job fials.
If you have not installed SQL mail, you can use SMTP mail and write a step at the end of the job to email yourself. Indicate that this step should be run when some previous step or steps fail (on Failure) To use SMTP mail download some program like xp_smtp_sendmail or microsofts stored proc for doing this http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839
Francis
March 9, 2004 at 9:28 pm
We use CDOSYS to send mail. Below is the link to the article.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply