SQL Job Output file - Can I append datetime?

Question

question

zadien asked Oct 7, '11

SQL Job Output file - Can I append datetime?

Hello, So I have a simple select statement running at a specified time everyday. I'd like to append the current date and time to the output file. Is it possible to achieve this in the 'JOB STEP' properties under the 'Command Line' tab?

sql-agent job output

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim commented · Oct 07, 2011 at 09:00 AM

Where are you wanting to append the date time to? In the file name?

0 ·

zadien commented · Oct 07, 2011 at 09:33 AM

Yes, the filename.

0 ·

zadien commented · Oct 07, 2011 at 09:34 AM

e.g. OUTPUTFILE10072011.txt

0 ·

Answer 1 · 2011-10-07T11:01:06Z

Tim answered Oct 7, '11

The way I would handle this would be through SSIS, but in the job step you could execute command line and use DOS or any other scripting language to rename your output file.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question