That worked great, thanks Nick!

-----Original Message-----
From: Nick McNair [mailto:Nick.McNair@A...]
Sent: Wednesday, July 03, 2002 8:35 AM
To: sql language
Subject: [sql_language] RE: Saving output from a stored procedure ran as
a job


Assuming you using MS SQLServer:

Edit job step, click advanced tab.
give the 'Output filename: ' filename for 'Transact-SQL Script command
options'.... remember this will be relative to the server and the security
context the job will run in will that of SQLAgentCmdAxec.

Good Luck

Nick

-----Original Message-----
From: Nathan Nelson [mailto:Nathan.Nelson@C...]
Sent: 03 July 2002 15:25
To: sql language
Subject: [sql_language] Saving output from a stored procedure ran as a
job


Hello All,

I have a stored procedure that runs as a job and I want to save the
output from the stored procedure much like you can mannualy save the output
if ran from query analyzer.  Is this possible?

Nate



*********************************************************************
This message and any attachments are confidential and should only be
read by those to whom they are addressed. If you are not the intended
recipient, please contact us, delete the message from your computer 
and destroy any copies. Any distribution or copying without our prior
permission is prohibited. 

The Achilles Group does not accept legal responsibility for the 
contents of this message. The recipient is responsible for verifying 
its authenticity before acting on the contents. Any views or opinions 
presented are solely those of the author and do not necessarily 
represent those of the Achilles Group.

This email has been scanned by MAILsweeper and Sophos Anti-Virus 
products. However, The Achilles Group will have no liability for any 
viruses contained in this email or any attachment with this email.
*********************************************************************