sql server agent jobs history

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » sql server agent jobs history

sql server agent jobs history

Rate Topic

Display Mode

Topic Options

Author

Message

shiv-356842

Posted Tuesday, October 02, 2012 4:12 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 12:08 AM
Points: 239, Visits: 1,027

Hi Team,

SQL SERVER Agent jobs subplan_1,Plan_2, Plan_3 .. Etc i m not able see jobs history could you please suggest how can we see the history?

sqlagent-->properties-->History log size = 1000 and Job history rows per job =100 but i m not able to see subplan job history please suggest where can changed any thing.

Post #1366937

scogeb

Posted Tuesday, October 02, 2012 11:12 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 2:18 PM
Points: 64, Visits: 316

What other jobs do you have scheduled? Has that job even ran yet?

Some of my infrequently running jobs won't show up in history either because even at the settings you specified, the history fills up quickly, especially with a database mirroring job.

Post #1367189

saidapurs

Posted Wednesday, October 03, 2012 3:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:46 AM
Points: 167, Visits: 413

Hi Shiva,

Are you executing history cleanup job inside any job??

Thanks & regards
Satish

Post #1367479

« Prev Topic | Next Topic »

Permissions