Job steps problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Job steps problem

Hi I created job with two steps.
But whenever i try to run it it will ask me to choose step.
What do i do wrong? thank you
I don’t think you do anything wrong.
That’s the way SQL Server EM behaves when you start a job with multiple steps.
If you will start same job from Query Analyzer it will be no problem:
USE msdb
EXEC sp_start_job @job_name = ‘Job name’ Alex
Thank you Alex I am sitting here with troubleshooting already an hour!
If you will open Steps tab on the Job Properties, you will see a green flag in the step which is going to be started as a first step.
You can change that when you creating a job or after.
Here is why. If you have a job with 5 steps and this job failed on step # 3, you want to start this job with a step # 4.
That is where you will use this screen or if you are executing this job from stored procedure you will use sp_start_job sproc with @step_name argument. Alex
Yes the behaviour is by default if you manually execute the job, due to multiple steps involved in the job.<br /><br />Whereas if you schedule it so it will carry from STEP 1 to last step as indicated.<br /><br />There is no issue or wrong approach in your case <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of knowledge sharing.</font id="size1"></font id="teal"></center>