Wednesday, March 21, 2012

Listing all scheduled tasks on a server

I am trying to use

sp_help_jobstep

to detail the scheduled tasks on my server.

However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?

Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?

I am using SQL 7 and got this SP from bol.

ThanksOriginally posted by FunkyD
I am trying to use

sp_help_jobstep

to detail the scheduled tasks on my server.

However I get an error saying the stored proc does not exist. Is it not installed by default or is it possibler it was deleted somehow?

Is there another way I can extract all my scheduled tasks so that I can produce a SQL script to automate their re-creation if they get deleted?

I am using SQL 7 and got this SP from bol.

Thanks

Fixed it - forgot that you have to run against MSDB...lol

No comments:

Post a Comment