September 18, 2002 at 2:21 pm
I am using SQL Server 2000. I have to create 20 different reports and then email them to a client. I have created the stored procedures that generate the reports individually. All of the stored procedures take the same parameter. So I created another stored procedure that executes each stored procedure to generate the reports I need.
I want to create a job that executes this stored procedure and then emails all of files to the client. I would also like to zip all of the files into a single file.
Any help would be much appreciated.
Chris Jacoby
September 18, 2002 at 2:43 pm
DST might be the easiest. Or use multiple steps. One to run the sproc. You might need to use xp_cmdshell running isql to create the ouptu file.
For the zipping, use xp_cmdshell to run pkzip.
xp_sendmail will send an attached file.
Steve Jones
September 19, 2002 at 3:51 pm
Thanks for shoving me in the right direction, although instead of using isql I used osql.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply