Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chourasia
Starting Member
3 Posts |
 Posted - 2004-09-14 : 02:57:25
|
| I had created 1 job. In it I have 3 steps. Now I want to go to step no. 2 only when condition satisfies in step no. 1.Condition is:"if (select count(*) from tnp where tnpdate=GetDate()) > 0".If count is > 0, then RETRY it;Else goto step no. 2;So, how can pass parameters/ values in it...bcz it is going to next step always. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-14 : 03:12:09
|
refer to BOL, here's a portion of it...quote:
[@on_success_step_id =] success_step_idIs the ID of the step in this job to execute if the step succeeds and success_action is 4. success_step_id is int, with a default of 0. [@on_fail_action =] fail_actionIs the action to perform if the step fails. fail_action is tinyint, and can be one of these values.Value Description (action) 1 Quit with success 2 (default) Quit with failure 3 Go to next step 4 Go to step on_fail_step_id [@on_fail_step_id =] fail_step_idIs the ID of the step in this job to execute if the step fails and fail_action is 4. fail_step_id is int, with a default of 0.
|
 |
|
|
|
|
|
Job Step in Server Agent