February 20, 2013 at 3:48 am
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
February 20, 2013 at 4:00 am
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
February 20, 2013 at 4:13 am
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
February 20, 2013 at 4:19 am
What does SELECT COUNT(*) FROM [msdb].dbo.[sysjobhistory] s return?
February 20, 2013 at 8:23 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply