Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to set up the notification in the subject with Job status

Status
Not open for further replies.

dba123123

Technical User
Sep 5, 2001
16
0
0
CA
Hi,

Can anybody guide me to set up the scheduled job notification with following requirement:

When the email reachs the operator, it will show in the subject as job name and the job status(failed or success)

i.e. subject: job1 (failed)

I realized the all maintenance plan job has status on the subject line, but not for the ones I scheduled for the DTS jobs. The scheduled DTS packge is showing the job name and the server name, but I want to add the status to the subject line. Can I do it in Enterprise Manager. I use SQL server 7.0.

Thanks.

Laura

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top