SQL 2014 and above the Agent job text logs - how to redirect?

• Warren Peace

  SSCertifiable

  Points: 5881

  More actions

  April 29, 2021 at 5:25 pm

  #3877490

  For each of our backup jobs in SQL, they are management jobs as SSIS, when they run they create text log files each datecoded.

  How/where do I make the change to redirect them (each job individually) to a different drive/folder?

  I looked at the SSIS package, the Agent job itself but can't find it.

   

  Thanks

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  April 29, 2021 at 5:56 pm

  #3877511

  On the job step in the advanced section there should be a job output file location if it is controlled via the job.