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 2, 2012 4:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 5:24 AM
Points: 241, Visits: 1,202
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 2, 2012 11:12 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 65, Visits: 404
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 3, 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