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

sql server agent jobs history Expand / Collapse
Author
Message
Posted Tuesday, October 02, 2012 4:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 20, 2014 11:59 PM
Points: 239, Visits: 1,135
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
Posted Tuesday, October 02, 2012 11:12 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 11:46 AM
Points: 64, Visits: 379
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
Posted Wednesday, October 03, 2012 3:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi Shiva,

Are you executing history cleanup job inside any job??

Thanks & regards
Satish
Post #1367479
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse