Daily problems and issues that are hard to resolve about SSMS,SSRS,SSIS,SSAS,DTS,Agent, Optimization, Administration, Always On, Clustering, Point in Time recovery and more...
Search This Blog & Web
Wednesday, February 6, 2013
How can you find the stored procedure used by SQL Job
Using following query we can find procedure used in SQL Job.
usemsdb go selectsj.nameasjob_name,st.command fromsysjobssjjoinsysjobstepsst onsj.job_id=st.job_id wherest.commandlike'%Procedurename%'
No comments:
Post a Comment