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
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