SDU Tools: ExecuteJobAndWaitForCompletion

added by DotNetKicks
8/1/2018 2:13:10 PM

1449 Views

You can execute SQL Server Agent jobs from within T-SQL code. The procedure sp_start_job can do that. That's all well and good but notice that it doesn't say "execute job"; it just says "start job". The command starts the execution of a job but has no interest in when it completes.


0 comments