If you have hundreds of sql jobs scheduled to run everyday in SQLserver. How quickly you can find the stored procedure used by sql job command.
Here is simple solution to find it.
use msdb
go
select sj.name as job_name, st.command
from sysjobs sj
join sysjobsteps st
on sj.job_id = st.job_id
where st.command like '%uspMyBook%'
Here is simple solution to find it.
use msdb
go
select sj.name as job_name, st.command
from sysjobs sj
join sysjobsteps st
on sj.job_id = st.job_id
where st.command like '%uspMyBook%'