locked
sql agent output file RRS feed

  • Question

  • Hi,

    I have scheduled a job on sql agent on a daily basis. The output of which I am directing to outputfile. The problem is I would like to assign a new file for every run. I have a vb script generating the datetimestamp_output file. How do I assign it? i.e Under advanced page of steps, the output file destination should be like C:\20090323_output.txt[2*_output.txt], I tried & it doesnt work. Please help.

    Thanks

    Monday, March 23, 2009 6:35 AM

All replies

  • Search in Books Online for "Agent Token" and you will find a way to do it (adding tokens for job startd date and job start time to output file name).
    Tibor Karaszi
    Monday, March 23, 2009 8:28 AM
  • Hello anrbr,

    After giving the path at "Output file" under "Advanced tab, you need to check the check box "Append output to existing file". Then only the ouput file is appended.

    If you did so.Then let me know even after you get the same issue.


    Thanks,
    Prashanthi
    Monday, March 23, 2009 8:56 AM