xp_sqlagent_enum_jobs是微軟未公開的存儲過程，用于取得作業的相關信息，在自己進行調度處理多作業時，用它來判斷作業的執行情況再合適不過了。
create table #help_job(
    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, -- bool
    request_source int not null,
    request_source_id sysname null,
    running int not null, -- bool
    current_step int not null,
    current_retry_attempt int not null,
    job_state int not null
)--判斷作業是否正在運行
    while @job_run_flag = 1
    begin
        --刪除臨時表信息
        delete #help_job
        --添加信息
        insert into #help_job
        execute master.dbo.xp_sqlagent_enum_jobs 1, 'sa'
       
        if exists (select * from  msdb.dbo.sysjobs a,#help_job b where a.job_id=b.job_id and a.name='job1' and b.job_state = 4 and b.request_source_id is null)
        begin
            set @job_run_flag = 0
        end
        else
        begin
            --延時一分鐘
            waitfor delay '000:01:00'
        end

    end

    --執行其他作業
    exec msdb.dbo.sp_start_job @job_name = 'job1'

    --更新服務器狀態
    --update sys_server set updateflag = 0 where pid = @pid
    set @job_run_flag = 1
b.request_source_id is null一定要加上，否則多次啟動同一個作業的時候有可能報錯。

我的存儲過程，大家可以借鑒一下

create procedure proc_pmis_main
as

--更新準備
exec proc_pmis_updateready

--臨時表
create table #help_job(
    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, -- bool
    request_source int not null,
    request_source_id sysname null,
    running int not null, -- bool
    current_step int not null,
    current_retry_attempt int not null,
    job_state int not null
)

--作業是否正在運行
 --1：正在運行;0:未運行
declare @job_run_flag int
set @job_run_flag = 1
declare @pid int
--循環提取數據
declare area_cursor cursor for
select pid from sys_server where updateflag = 1 and useflag = 1 order by pid

open area_cursor
fetch next from area_cursor into @pid
while @@fetch_status =0
begin
    --判斷作業是否正在運行
    while @job_run_flag = 1
    begin
        --刪除臨時表信息
        delete #help_job
        --添加信息
        insert into #help_job
        execute master.dbo.xp_sqlagent_enum_jobs 1, 'sa'
       
        if exists (select * from  msdb.dbo.sysjobs a,#help_job b where a.job_id=b.job_id and a.name='job_pmis_synch' and b.job_state = 4 and b.request_source_id is null)
        begin
            set @job_run_flag = 0
        end
        else
        begin
            --延時一分鐘
            waitfor delay '000:01:00'
        end

    end

    --執行同步作業
    exec msdb.dbo.sp_start_job @job_name = 'job_pmis_synch'

    --更新服務器狀態
    --update sys_server set updateflag = 0 where pid = @pid
    set @job_run_flag = 1
    --print (@pid)

    fetch next from area_cursor into @pid
end
close area_cursor
deallocate area_cursor

drop table #help_job
go