Post reply

SQL Agent job output to a dynamic location

  • July 30, 2010 at 8:56 am

    #221976

    I am trying to figure out a way to write Output file on the advanced settings for a SQL agent job step to a dynamic location. I am trying to create a single job for several database servers that don't necessarily have access to the same location on the server. I thought of setting an environment variable on each server and reference that variable as the path for the Output file, but that didn't work. For example

    Server 1 writes to c:\logfiles

    Server 2 writes to f:\logfiles

    Etc.

    Any direction will be appreciated

    Dep

  • August 1, 2010 at 11:22 pm

    #1200849

    Y cant u create different environment variables for different servers pointing the different shared locations for backup in the same server where u creating the job??

  • August 2, 2010 at 11:02 am

    #1201142

    I am creating the job on the MSX master server to run on all the target servers. If I point the output log to c:\logfiles, it works perfectly, except for Windows 2008/SQL 2008 clusters where c:\ is not a clustered resource that SQL has access.

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

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