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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect.
ASKER