編寫人：CC阿爸

2014-6-17

在日常SQL數據庫的操作中，常常需要查詢那些對象，如那些sp會包括對該表的操作，那些job會對應執行該sp等相關內容。總之是快捷的修改與之有關的內容。

select b.name

from syscomments a,sysobjects b where a.id=b.id and b.xtype='P' and a.text like '%指定內容%'

select * from syscomments where text like '%Job_CalKPI%'

SELECT * FROM sysobjects WHERE xtype='P'

SELECT * FROM sysobjects WHERE id='373784589'

select * from syscomments where id='2137878783'

sp_help_job

select * from msdb.dbo.sysjobs

select * from msdb.dbo.sysjobschedules

select b.job_id, b.name,b.description,b.enabled from msdb.dbo.sysjobsteps s ,msdb.dbo.sysjobs b

where s.job_id=b.job_id and s.command like '%指定內容%'