DECLARE @JobID VARCHAR(36), @retval INT SELECT @JobID = Job_ID FROM msdb.dbo.sysjobs_view WHERE [Name] = 'SQL Job Name' EXEC @retval = msdb.dbo.sp_start_job @job_id = @JobID GO
Asked In: Many Interviews | Alert Moderator
Login to post response