September 11, 2012 at 8:56 pm
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.
September 11, 2012 at 9:24 pm
You can set an alert to text or email you.
You can also create a job that checks for any failed jobs and then emails job results to you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 11, 2012 at 10:35 pm
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.
September 11, 2012 at 10:47 pm
We have alert set virtually for everything but that day it didn't run due to sql server agent issue.
The error we got on sql server agent log was :-
SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you.
Is there any way through which we can check that particular job in a schedule has not run.
September 11, 2012 at 10:58 pm
You can query the sysjobactivity table in msdb to get various information regarding execution dates and times. The trouble with a job that doesn't run is that you won't find a log anywhere of it actually failing to execute so you will need to infer this from the sysjobxxx tables.
And do investigate the error you posted up further.
September 14, 2012 at 6:52 am
I have a PS script that interrogates JobServer.Jobs on all servers across my estate at 7am.
So when I come into work it has emailed me a single email for each server if jobs have failed with the server name and the name of the job that has failed.
The same PS script also fills an Excel sheet and colour codes the results RAG for Failed Unknown Success which I check every day
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 19, 2012 at 3:04 pm
mrrobsewell (9/14/2012)
I have a PS script that interrogates JobServer.Jobs on all servers across my estate at 7am.So when I come into work it has emailed me a single email for each server if jobs have failed with the server name and the name of the job that has failed.
The same PS script also fills an Excel sheet and colour codes the results RAG for Failed Unknown Success which I check every day
Nice! Care to share? If you don't mind post the script to this thread or contribute to the site by clicking the Write For Us link on the left nav.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply