Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    7

    Unanswered: Where to see job History??

    Hi,

    i have my job running every 5 min. I want to view the history log. In job history it shows only few hundreds of records.. But i want to see from begining. Can anyone tell me, where to view whole log of job history??

    Thanks in Advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The job history cycles over time. I believe only about 5000 records are kept by default. After that, the older ones start getting deleted. If you want to change this, you will need to check under the properties of SQL Agent in SSMS. It should be in the Job section.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •