Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Change the job history log

    Hello,

    Thanks for your answer. I had not thought this.

    The solution is :

    EXEC msdb.dbo.sp_purge_jobhistory @oldest_date=GETDATE()-14

    EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=-1,

    @jobhistory_max_rows_per_job=-1

    Thanks

    Nicolas

    December 29, 2011 at 7:27 am

    #1426436

Viewing post 1 (of 2 total)