Enterprise manager scheduled jobs

[Aohene]

Hello,

I have a job scheduled within Enterprise manager. How can I configure this job, within enterprise manager, to generate output files having the current system date and time as part of the output file names.

Regards,

Albert


NB: It is not a backup job just a simple query.

[skhanal]

You can write script to generate file name by tagging current date time.

then build a string with osql command to pass the query as -Q"" and put filename as -o parameter and execute the string with xp_cmdshell.


exec xp_cmdshell @sqlstring