Jobs logged in the "Job Activity Monitor" but not in the "View History"

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Jobs logged in the "Job Activity Monitor" but...

Jobs logged in the "Job Activity Monitor" but not in the "View History"

Rate Topic

Display Mode

Topic Options

Author

Message

fasttrack

Posted Wednesday, February 20, 2013 3:48 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 351, Visits: 150

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

s_osborne2

Posted Wednesday, February 20, 2013 4:00 AM

SSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 614, Visits: 1,872

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

Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne

Post #1422016

fasttrack

Posted Wednesday, February 20, 2013 4:13 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 351, Visits: 150

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

s_osborne2

Posted Wednesday, February 20, 2013 4:19 AM

SSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 614, Visits: 1,872

What does

SELECT COUNT(*) FROM [msdb].dbo.[sysjobhistory] s

return?

Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne

Post #1422020

opc.three

Posted Wednesday, February 20, 2013 8:23 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:57 PM
Points: 6,724, Visits: 11,771

fasttrack (2/20/2013)

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1422115

« Prev Topic | Next Topic »

Permissions