sysjobsteps  
Author Message
GutzE





PostPosted: Tue Dec 07 08:44:44 CST 2004 Top

SQL Server >> sysjobsteps

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

SQL Server192  
 
 
Jacco





PostPosted: Tue Dec 07 08:44:44 CST 2004 Top

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


 
 
stoney





PostPosted: Tue Dec 07 09:45:03 CST 2004 Top

SQL Server >> sysjobsteps perfect

thx



> 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
>
>
>
 
 
stoney





PostPosted: Tue Dec 07 09:45:06 CST 2004 Top

SQL Server >> sysjobsteps perfect...

thx



> 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
>
>
>