作业的使用示例_创建定时调用存储过程的作业.sql_weixin_34208283的博客

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_JobSet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) if exists (select * from dbo.sysobject