Получить список активных заданий агента MS SQL сервера

USE [master]
GO
 
/****** Object:  LinkedServer [loopback]    Script Date: 15.07.2025 15:15:22 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'loopback', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N'.', @catalog=N'master'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'loopback',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'collation compatible', @optvalue=N'false'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'data access', @optvalue=N'true'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'dist', @optvalue=N'false'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'pub', @optvalue=N'false'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'rpc', @optvalue=N'true'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'rpc out', @optvalue=N'true'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'sub', @optvalue=N'false'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'connect timeout', @optvalue=N'0'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'collation name', @optvalue=null
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'lazy schema validation', @optvalue=N'false'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'query timeout', @optvalue=N'0'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'use remote collation', @optvalue=N'true'
GO
 
EXEC master.dbo.sp_serveroption @server=N'loopback', @optname=N'remote proc transaction promotion', @optvalue=N'false'
GO

Drop table if exists #t;
GO
CREATE TABLE #t (
    job_id UNIQUEIDENTIFIER
    ,originating_server NVARCHAR(128)
    ,[name] NVARCHAR(128)
    ,[enabled] TINYINT
    ,[description] NVARCHAR(512)
    ,start_step_id INT
    ,category NVARCHAR(128)
    ,[OWNER] NVARCHAR(128)
    ,notify_level_eventlog INT
    ,notify_level_email INT
    ,notify_level_netsend INT
    ,notify_level_page INT
    ,notify_email_operator NVARCHAR(128)
    ,notify_netsend_operator NVARCHAR(128)
    ,notify_page_operator NVARCHAR(128)
    ,delete_level INT
    ,date_created DATETIME
    ,date_modified DATETIME
    ,version_number INT
    ,last_run_date INT
    ,last_run_time INT
    ,last_run_outcome INT
    ,next_run_date INT
    ,next_run_time INT
    ,next_run_schedule_id INT
    ,current_execution_status INT
    ,current_execution_step NVARCHAR(MAX)
    ,current_retry_attempt INT
    ,has_step INT
    ,has_schedule INT
    ,has_target INT
    ,[type] INT
    )
GO
insert #t
EXEC ('exec msdb..sp_help_job @execution_status = 1') at [loopback]
GO
Select * from #t