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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment