T-sql procedure to wait for sql server agent job
/* Awaits job to finish, then returns job_status 0 = Failed 1 = Succeeded 2 = Retry 3 = Canceled null = Job never executed / no history If job was executed and already finished successfully before this proc starts, it will return 1 (success) */ create procedure tools . AwaitSqlServerAgentJob @jobName sysname as declare @jobid uniqueidentifier = ( select job_id from msdb . dbo . sysjobs where name = @jobname ) declare @sessionId int = ( select max ( session_id ) from msdb . dbo . sysjobactivity ...