How to run this?? 2

[icemel]

Hi,

I used a spreadsheet to create multiple lines of the same command but with different parameters.

For example:

sp_help_jobschedule @job_name = "job1"
sp_help_jobschedule @job_name = "job2"
sp_help_jobschedule @job_name = "job3"
etc

Now, I want to run these multiple lines in a query analyzer window. But, I am getting an error on line 2.

How can I get these statments to run one after another without running them one at a time? I want to output a list of information.

Thanks much

 

[SQLDenis]

put exec in fron ot the procs

exec sp_help_jobschedule @job_name = "job1"
exec sp_help_jobschedule @job_name = "job2"
exec sp_help_jobschedule @job_name = "job3"

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

You can put GO between each line. You'll end up getting multiple recordset (1 for each command).

Alternatively, you could create a temp table with a structure that matches the data returned from sp_help_jobschedule and then do an Insert/exec on each line. Finally, you would want to select from the temp table.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[icemel]

forgot about exec... must be getting senile in my old age