SQLTeam.com | Weblogs | Forums

Job Output to new file


#1

In the Output file option for a job step you can select two options, one is to create a new file each time, the other is to append the output to the existing file.

Is there any way to add a new output file each time the job is executed and just append the date to the file?

I don't want to overwrite the output file each time the job is run, nor do I want a large file that contains months and months worth of output.