I need to create a report & run weekly to output to file on server with filename_date×uffix.txt.
The original report (which is just procedure output) runs as a job.
For security reasons, xp_cmdshell is disabled & I can't invoke a cmd script from jobs (to pop a suffix onto the end of the filename).
What is the best & simplest way to do this?
2005 sp4 ent