网(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 |