Post reply

Job's history

  • April 17, 2008 at 1:29 am

    #123442

    Hi all,

    i created one job with the schedule of every 10 minutes,

    while viewing the history of that job,

    i got the results on the current date only (today)

    i want the history of yesterday or day before yesterday how can i got it?

    Thanks and Regards,

    N.Prabhakaran

  • April 18, 2008 at 4:21 pm

    #804621

    Right-click on the SQL Server Agent in Enterprise Manager, select the "Job System" tab, and increase the value for "Maximum job history rows per job".

    I believe the default is 100. If your job runs every 10min, then it runs 144 times per day. This is the reason you can only see history for the current day.

  • April 18, 2008 at 10:00 pm

    #804637

    Thank U Edogg,

    I got it.

    Thanks and Regards,

    N.Prabhakaran

  • June 30, 2009 at 10:11 am

    #1017723

    I have same problem.I have update statistics job that run weekly. When i go to view history from right click on job, it is not showing any entry. History per job also set to 100. what else need to be setup?

  • July 1, 2009 at 3:15 am

    #1018240

    Increase the value to 500 or 1000

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

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