Intellisense for system stored procedure parameter values
For system stored procedures, some parameters have a predefined set of possible values, e.g. msdb.dbo.sp_add_jobstep has the parameter @on_success_action.
The MS documentation lists this predefined list of possible values:
1 (Default) Quit with success
2 Quit with failure
3 Go to next step
4 Go to step @on_success_step_id
It would be great if Intellisense could suggest values for these sorts of parameters, saving a trip to Microsoft's website.
1
vote
Cameron Schultz
shared this idea