Hello,

I have set up some jobs on SQL 2005 Standard Edition SP2 (9.0.3042) 64-bit, including hourly transaction log backups. I tested out the jobs by setting the Notifications section to send an email to the operator when the job completes. (I thought at first I had picked "When the job succeeds," but I picked "When the job completes.")

I tested the jobs successfully and switched the Notifications section to send an email "When the job fails." However, I am still getting the email notifications, even though the jobs are succeeding.

I ran SELECT * FROM sysjobs in msdb to check that the setting was correct in the sysjobs table, and it is - the notify_level_email column is set to 2, which means "When the job fails" according to the sysjobs table description at MSDN:

http://msdn.microsoft.com/en-us/library/ms189817.aspx

Does anyone know why the job is not "listening" to the updated notification setting? How can I correct its behavior?

Thanks for any help!

-jrdevdba

Once it is modified, it should not pickup the old behaviour but...you can try restaring the SQL Agent

 Thanks - I tried restarting SQL Server Agent using the Take Offline/Bring Online command in the Cluster Administrator (it's a clustered db). Is that correct or should I restart from within SSMS?

Thanks again,
jrdevdba