Проверка статуса при запуске джоба

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET NOCOUNT ON
GO
 
CREATE FUNCTION [fn_JobStatusCheck_GAS_log1] (@job_owner sysname)
RETURNS BIT
AS
BEGIN
 
    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)
 
    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 = 'MyJobName' 
 
    RETURN @IsJobRunning 
END
GO