sql agent output file

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

Answer 1

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

Answer 2

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