InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 15:06:42 GMT20http://www.sqlservercentral.com/Forums/Topic1357770-146-1.aspx[quote][b]mrrobsewell (9/14/2012)[/b][hr]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[/quote]Nice! Care to share? If you don't mind post the script to this thread or contribute to the site by clicking the [i]Write For Us[/i] link on the left nav.Wed, 19 Sep 2012 15:04:05 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1357770-146-1.aspxI 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 dayFri, 14 Sep 2012 06:52:24 GMTmrrobsewellhttp://www.sqlservercentral.com/Forums/Topic1357770-146-1.aspxYou 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.Tue, 11 Sep 2012 22:58:05 GMTMissTippsInOzhttp://www.sqlservercentral.com/Forums/Topic1357770-146-1.aspxWe 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.Tue, 11 Sep 2012 22:47:32 GMTmahesh.dasonihttp://www.sqlservercentral.com/Forums/Topic1357770-146-1.aspx[quote][b]mahesh.dasoni (9/11/2012)[/b][hr]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.[/quote]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. Tue, 11 Sep 2012 22:35:45 GMTMissTippsInOzhttp://www.sqlservercentral.com/Forums/Topic1357770-146-1.aspxYou 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.Tue, 11 Sep 2012 21:24:44 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1357770-146-1.aspxWe 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.Tue, 11 Sep 2012 20:56:48 GMTmahesh.dasoni