摘要:
存储过程中调用:select distinct name from syscomments a,sysobjects b where a.id=b.id and b.xtype='p' and lower(text) like '%proc_name%' job中调用:SELECT b.[name] [Job名称],CASE WHEN b.enabled=1 THEN '启用' ELSE '禁用' END [是否启用],b.description [Job描述],a.step_name [步骤名称],a.command [执行语句 阅读全文