SQL Server >> sysjobsteps
From the "sp_help_jobstep" topic in Books Online:
1 = Quit the job reporting success.
2 = Quit the job reporting failure.
3 = Go to the next step.
4 = Go to step.
If the value is 4, you can find the id of the step the execution will go to
in the column on_success_step_id.
--
Jacco Schalkwijk
SQL Server MVP
> on_success_action is a tinyint with values ranging from 1 to 4. Does
> anyone
> know the english decription of 1 to 4? Unable to find anythin.
>
> If you look at sysjobs it idetifies what the bitmask stand for
>
> Thanks
> From the "sp_help_jobstep" topic in Books Online:
> 1 = Quit the job reporting success.
> 2 = Quit the job reporting failure.
> 3 = Go to the next step.
> 4 = Go to step.
>
> If the value is 4, you can find the id of the step the execution will go to
> in the column on_success_step_id.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> > on_success_action is a tinyint with values ranging from 1 to 4. Does
> > anyone
> > know the english decription of 1 to 4? Unable to find anythin.
> >
> > If you look at sysjobs it idetifies what the bitmask stand for
> >
> > Thanks
>
>
>
> From the "sp_help_jobstep" topic in Books Online:
> 1 = Quit the job reporting success.
> 2 = Quit the job reporting failure.
> 3 = Go to the next step.
> 4 = Go to step.
>
> If the value is 4, you can find the id of the step the execution will go to
> in the column on_success_step_id.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> > on_success_action is a tinyint with values ranging from 1 to 4. Does
> > anyone
> > know the english decription of 1 to 4? Unable to find anythin.
> >
> > If you look at sysjobs it idetifies what the bitmask stand for
> >
> > Thanks
>
>
>