Skip step in job

[Bell1991]

I need to be able to skip a step in a job.

For example, based on the time the step is executing if it is past a certain time - skip the next step and continue on step 5. I know how to check the time - but how do i tell it where to execute next?

Thanks,
-Bell

 

[Catadmin]

Create a job step that checks your time. Then give it an On Success / On Failure property. In EM, in the job properties, Edit the Step and click the Advanced tab. It should allow you to choose which Step of the job you want it to "skip" to based on Failure or Success.

Hope that helps.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.

 

[Bell1991]

How would i create the job to check time?

I tried returning a variable to indicate if true/false - but i can't do that.

 

[SQLDenis]

just put something like this on step 4 for example

if datepart(hh,getdate()) < 4 -- check time here
begin
rest of step
end


so if the if is not true the execution will be skipped

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Bell1991]

Thank you