21 lines
497 B
Transact-SQL
21 lines
497 B
Transact-SQL
DECLARE @tpl VARCHAR(255)='exec msdb.dbo.sp_start_job @job_name= ''@job@''; '+CHAR(13)+CHAR(10)
|
|
DECLARE @q VARCHAR(MAX)='';
|
|
|
|
SELECT @q = @q + REPLACE(@tpl, '@job@', j.name)
|
|
FROM msdb.dbo.sysjobs j
|
|
WHERE name LIKE 'ActivePosTran distribution agent -%'
|
|
AND NOT EXISTS(
|
|
--the job is currently running
|
|
SELECT 1
|
|
FROM msdb.dbo.sysjobactivity sja
|
|
WHERE sja.job_id = j.job_id
|
|
AND sja.start_execution_date IS NOT NULL
|
|
AND sja.stop_execution_date IS NULL
|
|
)
|
|
|
|
IF @q <> ''
|
|
BEGIN
|
|
PRINT @q
|
|
EXEC(@q)
|
|
END
|