Can I have a specific step run in a SQL Agent job?
I have a multi-step SQL Agent job with steps 1-20. Is it possible to run one step only or is the only option to start the job at a particular step (and then watch as it runs through all subsequent steps)?
I've looked at the documentation for sp_start_job and have tried going through the GUI of SMSS, but can't figure out if it's possible to do this.
Solution 1:
Sure if you right click on the SQL Server Job and Start at Step. That will start at a certain point and then do the remaining steps after.
Open SQLServerManagementStudio
--> SQL Server Agent Job
--> Select the job
--> Right Click
--> Start Job At Step
--> Highlight the job and click START.
Update:
If you needed to do one step only couldnt you set the success to : Quit the job as Success