• mahesh.dasoni (9/11/2012)


    We have faced a scenario in which jobs are scheduled to run on daily basis,but one day what happened that the job didnt run and we didnt get any alert and as we work in a financial firm for which data is quite essential we suffered a heavy loss due to that job not running.

    Is there any way through which we can track that job didn't run due to any reason.As it is virtually not possible to go on each server and check each job has run or not for that particular day as there are many servers and lots of jobs in that.

    Urgent help is required.

    When you say the job didn't run, do you mean it never executed, or that it failed? If it is the former I would also be concerned to find out why the job didn't run and treat the root cause.

    In my environment I have a PS script that runs across my whole environment each morning picking up job failures by interrogating the sysjobhistory table on each server. It drops the results into a table on a management server and I have an SSRS report that I check each day.