会python真的可以为所欲为0(回)
353天前
这里还有人吗1(回)
538天前这里还有人吗0(回)
538天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
763天前到处都是羊，不想上班0(回)
843天前
鸽子
0(回)
847天前SET NOCOUNT OFF |
DECLARE @jobID UNIQUEIDENTIFIER --variable for job_id |
DECLARE planidCursor CURSOR FOR --used for cursor allocation |
SELECT job_id FROM msdb.dbo.sysjobs WHERE enabled=1 |
OPEN planidCursor |
FETCH NEXT FROM planidCursor INTO @jobID |
WHILE @@Fetch_Status = 0 |
BEGIN |
--disable SQL Server Agent Job - @enabled parameter value is 0, enabled parameter value is 1 |
EXEC msdb.dbo.sp_update_job @job_id=@jobID, @enabled = 0 |
|
FETCH Next FROM planidCursor INTO @jobID |
END |
CLOSE planidCursor |
DEALLOCATE planidCursor |
