SQLServerCentral / Administering / SQL Server 2005 / Jobs logged in the "Job Activity Monitor" but not in the "View History" / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 00:27:44 GMT20RE: Jobs logged in the "Job Activity Monitor" but not in the "View History"http://www.sqlservercentral.com/Forums/Topic1422014-146-1.aspx[quote][b]fasttrack (2/20/2013)[/b][hr]SQL Server 2005 Enterprise Ed,Hi guys,I have the following issue:There are some jobs running successfully. The execution is reported in the "Job Activity Monitor" highlighting the "Last execution" and "Next Execution", [/quote]This data comes from msdb.dbo.sysjobactivity and there is at least one row in that table for every job.[quote]but if I click on a specific job and select "View History" I do not see nothing (no filters are applied).[/quote]This data comes from msdb.dbo.sysjobhistory and there is not always a row in the table for every job/step.Wed, 20 Feb 2013 08:23:43 GMTopc.threeRE: Jobs logged in the "Job Activity Monitor" but not in the "View History"http://www.sqlservercentral.com/Forums/Topic1422014-146-1.aspxWhat does [code="sql"]SELECT COUNT(*) FROM [msdb].dbo.[sysjobhistory] s[/code] return?Wed, 20 Feb 2013 04:19:51 GMTs_osborne2RE: Jobs logged in the "Job Activity Monitor" but not in the "View History"http://www.sqlservercentral.com/Forums/Topic1422014-146-1.aspxHi thanks for your reply,but it looks ok:<Limit size of job histoty log> is selectedMaximum job history log size (in rows): 1000Maximum job history rows per job: 1000The jobs running are not more than 10 and only some of them run every 1 hour.So, the values set look OK.Do you have any further suggestions?ThanksWed, 20 Feb 2013 04:13:50 GMTfasttrackRE: Jobs logged in the "Job Activity Monitor" but not in the "View History"http://www.sqlservercentral.com/Forums/Topic1422014-146-1.aspxHi,If you have lots of jobs that run on that server you may need to update the history retention. If you right-click the sql agent and then go to History you can change the job history log limits.Thanks,SimonWed, 20 Feb 2013 04:00:40 GMTs_osborne2Jobs logged in the "Job Activity Monitor" but not in the "View History"http://www.sqlservercentral.com/Forums/Topic1422014-146-1.aspxSQL Server 2005 Enterprise Ed,Hi guys,I have the following issue:There are some jobs running successfully. The execution is reported in the "Job Activity Monitor" highlighting the "Last execution" and "Next Execution", but if I click on a specific job and select "View History" I do not see nothing (no filters are applied).Do you have any suggestion?Thanks Wed, 20 Feb 2013 03:48:09 GMTfasttrack