Home Dashboard Directory Help

SSMS shows wrong job step configuration when step is set to go to an invalid step when it succeeds by Wayne Sheffield



Sign in
to vote
Type: Bug
ID: 807996
Opened: 11/7/2013 11:03:54 AM
Access Restriction: Public
User(s) can reproduce this bug


If you create a job with a step that has an on-success action of going to a non-existent step, when you view the job in SSMS it incorrectly shows the step's on-success action to "Go to the next step".
This is applicable to SSMS in SQL Server 2012 SP2 and 2014CTP2.

I would expect it to show the success action as pointing to an invalid step, or just the step number. Showing it going to the next step is incorrect.
Sign in to post a comment.
Posted by Microsoft on 3/4/2014 at 2:40 PM
We've triaged this issue and do not plan to implement a change at this time.
Posted by Microsoft on 11/15/2013 at 9:11 AM
Thanks for the feedback. We'll keep this item active so that other members of the community get a chance to see it and provide their own input. We'll keep an eye on it as we plan the next big things for SQL.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
SSMS-MultiStepJobShowsWrongOnSuccessAction.sql 11/7/2013 2 KB