SQL Job History details

• mtz676

  SSCrazy Eights

  Points: 9214

  More actions

  March 16, 2016 at 1:17 am

  #399867

  How do I collect these 2 values as in the screenshot attached using SQL query.

  1.Limit size of job history log:

  2.Remove agent history:

  Thanks

• tindog

  SSCarpal Tunnel

  Points: 4892

  More actions

  March 16, 2016 at 4:09 am

  #1865537

  Check out some of the stored procedure's in MSDB, e.g 'msdb.dbo.sp_get_sqlagent_properties', this should point you in the right direction.

  LinkedIn