sql server agent jobs history RRS feed

  • Question

  • Hi Team,

    SQL SERVER Agent jobs subplan_1,Plan_2, Plan_3 .. Etc i m not able see jobs history could you please suggest how can we see the history?

    sqlagent-->properties-->History  log size = 1000 and Job history rows per job =100 but  i m not able to see subplan job history please suggest where can changed any thing.



    Tuesday, October 2, 2012 9:12 AM


All replies

  • Hi,

    Those look like jobs from a maintenance plan. You can right click on the plan itself and look at the history there.



    Tuesday, October 2, 2012 2:40 PM
  • I agree with Seth, maint plan history is more refined than job history (for maint jobs). However, there should be job history as well. My guess is that you reached the limit of 1000 rows for other jobs causing this history to be removed. I always up 1000 to 10000 or more just for this to no happen.

    Tibor Karaszi, SQL Server MVP | web | blog

    Tuesday, October 2, 2012 4:17 PM
  • Hi Team,

    As per your suggestion i have seen mainttaince plan history but in some situvsaction we need to see the subplan histoy some long back how can we do this.

    and more over job history also not appearing at least single row also please suggest me where can i change

    Please find the below attachment.


    Wednesday, October 3, 2012 7:33 AM
  • Hi Subu,

    Can you open and check log file from disk? The path of log file should be like - ...\Program Files\Microsoft SQL Server\MSSQL10_50.Instance\MSSQL\Log. Or you can check your settings from 'Configuration Manager' --> SQL Agent--> Properties--> Advance.


    Wednesday, October 3, 2012 8:47 AM
  • hi subbu

    check this url to get detail


    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by Shulei Chen Tuesday, October 9, 2012 9:56 AM
    • Marked as answer by Shulei Chen Thursday, October 11, 2012 9:53 AM
    Wednesday, October 3, 2012 9:03 AM
  • Did you change the max number of rows setting from 1000 to 10000, 20000 or some other more suitable value?

    Tibor Karaszi, SQL Server MVP | web | blog

    Wednesday, October 3, 2012 9:30 AM
  • Tibork

    i did as per your suggestion but no luck/


    I m exectuing that sps in our environment we will check the status.



    Wednesday, October 3, 2012 9:36 AM