Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Jobs logged in the "Job Activity Monitor" but not in the "View History" Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2013 3:48 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 15, 2013 7:37 AM
Points: 351, Visits: 152

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", 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



Post #1422014
Posted Wednesday, February 20, 2013 4:00 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, September 18, 2014 2:53 AM
Points: 702, Visits: 2,178
Hi,

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,

Simon




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1422016
Posted Wednesday, February 20, 2013 4:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 15, 2013 7:37 AM
Points: 351, Visits: 152
Hi thanks for your reply,

but it looks ok:

<Limit size of job histoty log> is selected

Maximum job history log size (in rows): 1000

Maximum job history rows per job: 1000

The 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?

Thanks




Post #1422018
Posted Wednesday, February 20, 2013 4:19 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, September 18, 2014 2:53 AM
Points: 702, Visits: 2,178
What does
SELECT COUNT(*) FROM [msdb].dbo.[sysjobhistory] s

return?




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1422020
Posted Wednesday, February 20, 2013 8:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
fasttrack (2/20/2013)

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",

This data comes from msdb.dbo.sysjobactivity and there is at least one row in that table for every job.

but if I click on a specific job and select "View History" I do not see nothing (no filters are applied).

This data comes from msdb.dbo.sysjobhistory and there is not always a row in the table for every job/step.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1422115
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse