網(LieHuo.Net)教程 通過創建新一個存儲過程，在內部循環檢查job的狀態，當發現其執行成功之后，返回0。
| 以下為引用的內容： Create PROCEDURE [dbo].[Proc_GetStatus] AS BEGIN SET NOCOUNT ON DECLARE @xp_results TABLE (job_id UNIQUEIDENTIFIER NOT NULL, last_run_date INT NOT NULL, last_run_time INT NOT NULL, next_run_date INT NOT NULL, next_run_time INT NOT NULL, next_run_schedule_id INT NOT NULL, requested_to_run INT NOT NULL, request_source INT NOT NULL, request_source_id sysname COLLATE database_default NULL, running INT NOT NULL, current_step INT NOT NULL, current_retry_attempt INT NOT NULL, job_state INT NOT NULL) DECLARE @job_owner sysname SET @job_owner = SUSER_SNAME() INSERT INTO @xp_results EXECUTE master.dbo.xp_sqlagent_enum_jobs 1, @job_owner DECLARE @IsJobRunning BIT SELECT @IsJobRunning = x.running FROM @xp_results x INNER JOIN msdb.dbo.sysjobs sj ON sj.job_id = x.job_id WHERE sj.name = N'Utilization Gather And Process' --Insert your job's name between the single quotes while @IsJobRunning=1 begin WAITFOR DELAY '00:00:20' INSERT INTO @xp_results EXECUTE master.dbo.xp_sqlagent_enum_jobs 1, @job_owner SELECT @IsJobRunning = x.running FROM @xp_results x INNER JOIN msdb.dbo.sysjobs sj ON sj.job_id = x.job_id WHERE sj.name = N'Utilization Gather And Process' --Insert your job's name between the single quotes end return 0 End |
程序員人生，我編程，我富裕，記住wfuyu網，php教程，php學習，php手冊，CMS模版制作
聲明：本站大部分內容是作者原創，少部分收集于互聯網供大家一起學習，原版權很多不明，如有侵權請聯系本站，謝謝！
粵ICP備14040726號-1?? 2015-2020 程序員人生 版權所有
