Notification message?

[sqlcasey]

SQL Server 2005

Is it possible to add a custom message to a job notification? For example, on job failure, I would like to add more info than just the job failed.

Thanks

 

[mrdenny]

Not really. If you add a seperate job step that all the jobs go to on failure, that step can send out any info that you want, then that step can report failure upon success.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

We use SMTP mail (xp_smtp_sendmail) as a final job step in many jobs just to get customized messages. Unfortunately, it seems notification mails are very generic.

However, have you tried setting up Alerts? This might help you out.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"