Press "Enter" to skip to content

Searching SQL Agent Command Text

Jack Vamvas shows us how to query SQL Agent job steps for a string:

Question: I’d like to find all SQL Server Agent Jobs with a certain string within the Command section . There’s been a change in reference to a database table, therefore I need to review all SQL Server Agent Jobs and check they are not referencing this database table. 

Read on for the answer.