T-SQL to find Procedures/Commands used in Sql Server Jobs

It becomes difficult to find a procedure from the huge cluster of Jobs through SQL Server Management Studio.

So below is the T-SQL that can list all the procedures and commands that are used in Sql Server Jobs

T-SQL to list all the procedures/commands used in Sql Server Jobs

use msdb
go
select sj.name as job_name, st.command
from  sysjobs sj
join sysjobsteps st
on sj.job_id = st.job_id

To identify/find a Sql Server Job where a particular procedure is used can also be retrieved by modifying the above T-SQL

T-SQL to identify/find a Sql Server Job where a particular procedure is used

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 '%Proc_toFind%'