Search object (table, stored procedure) in SQL server agent

  • adonetok

    SSCrazy Eights

    Points: 8356

    There are about 100 jobs in SQL server agent.

    Is there any way to search a table to view which jobs is including this table?

  • MVDBA

    SSC-Insane

    Points: 20806

    this is going to be painfull

    my advice would be to do it manually

    BUT if you query msdb.dbo.sysjobsteps there is a column called "command".. you could try and scrape proc and table names from that and then build a cursor to look at the procs and  check the object_definition to see if it includes that table

    other than that, use redgate sql search, look for the procs that use that table, then query sysjobsteps for anything that matches your list of procs

     

     

    MVDBA

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

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