How can i start the next job step of job in the same job?
I have tried like '--EXEC msdb.DBO.sp_start_job @job_name ='dhhjdhjj', @server_name = N'Sdhjhjfhjfhj',@step_name ='step1'
But getting the below error
Message
Executed as user: ssss-agent. SQLServerAgent Error: Request to run job 'dhhjdhjj' (from User ssss-agent) refused because the job is already running from a request by User PROD\5555ff. [SQLSTATE 42000] (Error 22022). The step failed.
Need:If records exists in the first step of job output,,next step of the same job will execute ,otherwise quit.
Try to resolve this error?
Regards,
Kumar