Post reply

SQL Agent Jobs showing NO history

  • November 22, 2018 at 2:00 am

    #2014321

    We had this problem and it was resolved by right clicking on the SQL Agent Job in Management Studio and selecting Script Job as and picking DROP and CREATE To a new query window and executing. The History appeared after the next call. We were on SQL2008R2.

  • November 27, 2018 at 11:13 am

    #2014705

    cheshirefox - Monday, September 10, 2012 1:55 PM

    Truthfully, I never found a solution. I've increased the setting size in the SQL Agent w/out much success.Would really like to know how to view the history, but right now, I don't have an answer.

    I think I had faced the same kind of issue what I did was ran this query to set the values of maximum number of rows for SQL Server Agent.
    I guess you will need to restart SQL Server  Agent as well.

    Query :
    USE [msdb]
    GO
    EXEC msdb.dbo.sp_set_sqlagent_properties
      @jobhistory_max_rows=999999,
      @jobhistory_max_rows_per_job=49999
    GO

Viewing 2 posts - 16 through 16 (of 16 total)

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