I need your help in creating a stored procedure which will kick off a sql server job (job has multiple steps). Using "msdb.dbo.sp_start_job" will just kicks off the job. But I want my stored procedure to kick off the job and wait till it completes.
I do not want to use WAITFOR DELAY function.
Please help me out!!
Thanks in advance!