Post reply

Query sql server agent jobs

  • July 9, 2013 at 9:22 am

    #279653

    Hi,

    I am dropping some legacy stored procedures.

    There are many jobs scheduled on production server. I dont know whether the stored procedures I delete are still used by any jobs or not.

    How can I query whether these procedures are used by any of the jobs or

    atleast I have SSIS packages which uses the dropped procedures. Can I query jobs to know whether these packages are called or not.

    I can't manually open each job and check. Sometimes the packages are called from master package.

    How can I search?

  • July 9, 2013 at 9:28 am

    #1630866

    You can query msdb.dbo.sysjobsteps and look for those procedures in the command column.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • July 9, 2013 at 9:47 am

    #1630877

    Hi,

    Thanks for the reply. It helped me a lot.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply