Link to home
Start Free TrialLog in
Avatar of warrenrapson
warrenrapson

asked on

query to extract SQL from SQL jobs with T-SQL steps

Hi all,

I'm looking for a query that I can use to query all my SQL Agent jobs that will expose/extract:
1. the jobs that have T-SQL steps, and
2. the SQL code of those jobs.

I need this to search all my jobs for references to a particular database.

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of warrenrapson
warrenrapson

ASKER

This is what I LOVE about Experts Exchange!!!
Perfect.