History of a SQL job

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  August 28, 2012 at 9:59 am

  #266680

  I'm trying to check the history of a SQL job. I'm able to see only last 15 days but I need to check for 30 days. Is there an alternative method to check for the history of a job for 30 days?

  Thanks,

  Sunny

• bangsql

  SSC Eights!

  Points: 900

  More actions

  August 28, 2012 at 10:08 am

  #1530923

  You need go on sql agent property / history and set the settings as per need

• sandeep rawat

  Ten Centuries

  Points: 1317

  More actions

  August 28, 2012 at 10:12 am

  #1530926

  hi sunny

  look into

  system table sysjobhistory

  For more info read

  http://msdn.microsoft.com/en-us/library/ms174997(v=sql.100).aspx.

  If still need help let me know.

  thanks