Hi,
I have this:
exec (insert into myTable sp_help_jobschedule @job_name = "job1")
exec (insert into myTable sp_help_jobschedule @job_name = "job2")
exec (insert into myTable sp_help_jobschedule @job_name = "job3")
but once again, syntax error on line 2. I'm sure it's something simple but not sure what.
Thanks
I have this:
exec (insert into myTable sp_help_jobschedule @job_name = "job1")
exec (insert into myTable sp_help_jobschedule @job_name = "job2")
exec (insert into myTable sp_help_jobschedule @job_name = "job3")
but once again, syntax error on line 2. I'm sure it's something simple but not sure what.
Thanks