SQL用脚本禁用作业 如何用SQL脚本来禁用作业? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 开始-- 运行-- net stop mssqlserveragent USE msdbGO--禁用JOBDECLARE @enable_or_disable BIT, @job_name SYSNAME, @job_id UNIQUEIDENTIFIERSELECT @enable_or_disable = 0, @job_name = 'Job_Name'--得到job_idEXEC dbo.sp_verify_job_identifiers '@job_name', '@job_id', @job_name OUTPUT, @job_id EXEC dbo.sp_update_job @job_name = @job_name, @enabled = @enable_or_disableEXEC dbo.sp_update_job @job_id, @enabled = @enable_or_disable--删除JOB/*IF EXISTS(SELECT TOP(1) 1 FROM dbo.sysjobs WITH(NOLOCK) WHERE [name] = @job_name) EXEC dbo.sp_delete_job @job_name = @job_name*/ USE msdbGO--禁用JOBDECLARE @enable_or_disable BIT, @job_name SYSNAME, @job_id UNIQUEIDENTIFIERSELECT @enable_or_disable = 0, @job_name = 'Job_Name'--得到job_idEXEC dbo.sp_verify_job_identifiers '@job_name', '@job_id', @job_name OUTPUT, @job_id OUTPUT--用job_name停止EXEC dbo.sp_update_job @job_name = @job_name, @enabled = @enable_or_disable--或用job_id停止EXEC dbo.sp_update_job @job_id, @enabled = @enable_or_disable--删除JOB/*IF EXISTS(SELECT TOP(1) 1 FROM dbo.sysjobs WITH(NOLOCK) WHERE [name] = @job_name) EXEC dbo.sp_delete_job @job_name = @job_name*/ 每次运行这个EXEC dbo.sp_update_job 都说找不到存储过程 为什么呢? sp_update_job这个存储过程是在msdb数据库下的。EXEC msdb.dbo.sp_update_job ... 求一SQL 求一SQL,光标题我说不清楚,请进来瞅瞅 求一存贮过程! 求一SELECT语句 如果写将带有数值的字符串类型数据查找出来的SQL语句 sqlserver2005打开的时候显示 未能加载包:microsoft sql management studio package是怎么回事啊? 2000S下设了几个用户怎么能让他们都能用C盘下的office2000啊?不会分别装吧 重装SQL,文件挂起的问题 如何用一条Select语句实现字符串分组相加?详情见内 sql server 连接超时的错误,高手请进!!,是数据库数据太大了!! 请教一个SQL问题 求一条语句,在某表内复制增加一批数据
GO--禁用JOB
DECLARE
@enable_or_disable BIT,
@job_name SYSNAME,
@job_id UNIQUEIDENTIFIER
SELECT
@enable_or_disable = 0,
@job_name = 'Job_Name'--得到job_id
EXEC dbo.sp_verify_job_identifiers '@job_name', '@job_id', @job_name OUTPUT, @job_id EXEC dbo.sp_update_job
@job_name = @job_name,
@enabled = @enable_or_disableEXEC dbo.sp_update_job
@job_id,
@enabled = @enable_or_disable
--删除JOB
/*
IF EXISTS(SELECT TOP(1) 1 FROM dbo.sysjobs WITH(NOLOCK) WHERE [name] = @job_name)
EXEC dbo.sp_delete_job @job_name = @job_name
*/
GO--禁用JOB
DECLARE
@enable_or_disable BIT,
@job_name SYSNAME,
@job_id UNIQUEIDENTIFIER
SELECT
@enable_or_disable = 0,
@job_name = 'Job_Name'--得到job_id
EXEC dbo.sp_verify_job_identifiers '@job_name', '@job_id', @job_name OUTPUT, @job_id OUTPUT--用job_name停止
EXEC dbo.sp_update_job
@job_name = @job_name,
@enabled = @enable_or_disable
--或用job_id停止
EXEC dbo.sp_update_job
@job_id,
@enabled = @enable_or_disable
--删除JOB
/*
IF EXISTS(SELECT TOP(1) 1 FROM dbo.sysjobs WITH(NOLOCK) WHERE [name] = @job_name)
EXEC dbo.sp_delete_job @job_name = @job_name
*/