Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    25

    Question Unanswered: 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.

    Thanks

  2. #2
    Join Date
    Mar 2003
    Posts
    25

    Re: Listing all scheduled tasks on a server

    Originally 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •