Post reply

Job History

  • November 8, 2011 at 5:50 am

    #259646

    Hi Folks,

    there is job in one of my server which runs on 24*7 basis.

    Two days ago that job was failed and we are receiving failure alerts. After modifying the job by developer it able to execute successfully.

    Now today in the job history am not able to see the failure step to know the description.

    kindly help me how to find the job when it was failed along with its description.

    TIA...

  • November 8, 2011 at 5:55 am

    #1404415

    You can look :-

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

    that's default location of it, if you haven't changed it

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • November 8, 2011 at 6:06 am

    #1404430

    How was the job saved?

    If it's dropped / rebuild, then the history is gone.

  • November 8, 2011 at 7:15 am

    #1404514

    SKYBVI (11/8/2011)

    You can look :-

    C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

    that's default location of it, if you haven't changed it

    This is not where job history are stored. They are in msdb database.

    ERRORLOG file contains the SQL Server error log.

  • November 8, 2011 at 9:14 pm

    #1404946

    I dont know whether job is saved or not?

    but in the Agent properties history has been set to 10000 rows and for each job 1000 rows.

    this job runs more than 1000 times in a day..

    Is it possible to get the one week old history of that job ..?

  • November 9, 2011 at 4:44 am

    #1405070

    MasterDB (11/8/2011)

    I dont know whether job is saved or not?

    but in the Agent properties history has been set to 10000 rows and for each job 1000 rows.

    this job runs more than 1000 times in a day..

    Is it possible to get the one week old history of that job ..?

    No.

    You'd need a couple backups of msdb to restore them and extra the info before it is deleted.

    If you have a full backup and the transaction log backups then you can do point in time restores stopping everday to extra the new info.

    You'll have to increase those limits if you want to see that history.

  • November 9, 2011 at 10:40 pm

    #1405513

    Hi Ninja..

    Thanks for giving valuable suggestion...

    🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply