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..
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:
Microsoft réalise une enquête en ligne pour comprendre votre opinion sur le site Web de Msdn. Si vous choisissez de participer, l’enquête en ligne vous sera présentée lorsque vous quitterez le site Web de Msdn.