Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
OJ
Starting Member
3 Posts |
Posted - 2006-05-09 : 18:01:56
|
Hello all, I'm fairly new to SQL and I am trying to pass the output from a SQL query to the input of a stored procedure.I have a query that checks for running SQL jobs in MSDB (msdb.dbo.sp_get_composite_job_info NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL). I want to pass the output of this query to a stored procedure that uses SMTP to E-mail(sp_send_cdosysmail). I have SMTP running on my windows server and the SP works like a charm. How do I get the output of the above query passed to the SP? Is it even possible?Thanks |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|