<div>
Yes, in fact the query you posted will work without a problem. If you need more specifics, post more information, especially about the jobs you have in mind - what is it? or do you mean SQL Server Agent jobs?
</div>


Yes, in fact the query you posted will work without a problem. If you need more specifics, post more information, especially about the jobs you have in mind - what is it? or do you mean SQL Server Agent jobs?

<div>
DAM<br />
<br />
that was fast worked like a charm :)
</div>


DAM

that was fast worked like a charm :)

<div>
<div class="content wysiwyg-content">
<br />
Is there any way for me to query the text inside the command steps of a job. I would like to look for strings there <br />
<br />
I am trying to do something like this<br />
<br />
Select * from some JobTable<br />
where someColumn like '%exec myStoreProc%'<br />
<br />

</div>
</div>



Is there any way for me to query the text inside the command steps of a job. I would like to look for strings there 

I am trying to do something like this

Select * from some JobTable
where someColumn like '%exec myStoreProc%'



Query Thru jobs

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.