• 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