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

  • adonetok

    SSCrazy Eights

    Points: 8364

    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 (Mike Vessey)


    Points: 21224

    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




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

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