locked
Job History details RRS feed

  • Question

  • Hi, i Need to know job history details for a job. when i check the Job view history details,  i found only today's job details. History job details are not there. however i tried to check the job details in sysjobhistory of msdb. there also only today's job details are there. right now, i want to know job details for past few runs. Please help on this.
    Thursday, January 5, 2012 11:48 AM

Answers

All replies

  • Murali,

    Could you please check that the filters are not there on the Log File Viewer.


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
    Thursday, January 5, 2012 2:39 PM
  • Murali,

    Please have a look to the SQL SERVER AGENT, Properties page, and confirm the settings.


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Edited by Manish_Kaushik Thursday, January 5, 2012 2:55 PM Edited the picture
    • Proposed as answer by Sandip Shinde Friday, January 6, 2012 11:12 AM
    • Marked as answer by Kalman Toth Thursday, January 26, 2012 6:24 PM
    Thursday, January 5, 2012 2:45 PM
  • Hi Manish,

    Thanks for the reply.

    I checked the above step but there is no use. there is no filters and Maximum job history size is 150000

    Thanks

    Murali

    Friday, January 6, 2012 8:32 AM
  • Murali,

    Also you must have seen that there is not any settings for the "Remove agent history older than"


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
    Friday, January 6, 2012 11:09 AM
  • Any progress?

    The following article has SQL Server Agent jobs related queries:

    http://www.sqlusa.com/bestpractices2005/startjobfromstoredproc/

    Job history log can be cleared manually also:

    http://msdn.microsoft.com/en-us/library/ms179338.aspx

     


    Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER GRAND SLAM
    • Marked as answer by Kalman Toth Thursday, January 26, 2012 6:25 PM
    Friday, January 20, 2012 8:03 PM