Wednesday, December 07, 2011 2:22 PM
i am trying to crate a notification which will notify me if an archive job doesnt run at all, i can sent up an alert which tells me if the job, runs successfully or if the job fails. but not sure how to do one if the job doesn't run all all. we had a problem where the job was disabled and we didnt catch it for two months since it never sent us a notification of success or failure. so what i am trying to do is to set one where we get notifified if it doesnt run at all..
Thursday, December 08, 2011 6:52 AMModerator
As you pointed, there will be not any notification about this job if it is disabled. The point here is how to pick up an alert once a job is disabled. One way to do this is to implement a trigger on sysjobs system table on msdb, to send an email via Database Mail if any job disabled. For more information, please refer to this article on this topic:
Auto alert for SQL Agent jobs when they are enabled or disabled
If you have feedback for TechNet Subscriber Support, contact firstname.lastname@example.org.
TechNet Community Support