Post reply

Modify Job Log Path

  • June 19, 2014 at 9:38 am

    #309312

    We are changing our drives this weekend.. and will have a different drive letter to write out job logs to.

    Currently we have quite a number of jobs.. and each step has something like..

    @output_file_name=N'E:\MSSQL\Job_Logs\Zemeter_SQD_ISA_LoadData.txt',

    Is there any way I can modify all these at one time.. and still retain our job history?

    The only way I now is to genterate a script job as.. and delete the old job and replace it with a new one.. thus loosing all job history.

    Thanks

  • June 19, 2014 at 9:56 am

    #1723334

    use sp_update_jobstep

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • June 19, 2014 at 10:46 am

    #1723358

    Thanks will do.

Viewing 3 posts - 1 through 2 (of 2 total)

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