Post reply

Deleting a job also deletes job history

  • June 16, 2009 at 9:14 am

    #205596

    I've found that I can create and run a job. Then verify that it generated history by viewing it in the Job Activity Monitory. However, if I then delete the job, the history also goes away. Has anyone else noticed this and is there a way to retrieve or view the history once a job is deleted?

    Kind Regards

    David

  • June 16, 2009 at 10:11 am

    #1010316

    Also the history will be trucated automatically when it reaches the threshold.

    I usually include a daily job to copy the jobs, steps, history... into tables in an admin database.

    It also gives a record of when jobs are changed which can be useful.

    I then report and monitor that database rather than the tables in msdb for historic data.


    Cursors never.
    DTS - only when needed and never to control.

  • June 16, 2009 at 10:31 am

    #1010327

    I agree, nightly backup is the way to go. Unfortunatley in this case, the individual created, executed and deleted the job before it could be captured.

Viewing 3 posts - 1 through 2 (of 2 total)

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