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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-10-17 : 10:22:21
|
| I have Created Sql server job having 4 steps. step 1 is Front End application disble mode step 2 is ssis package step 3 is ssis package step 4 is enable Front end Appicationmy Requirement is before Executing step 4 i need to Check the Status of step1,step2,step3 .if any one of the step is Failed ,my 4step Shold not Execute.other wise my 4 step should Execute.how to use Staus of previous step in jobsif any body knows the logic pls Explain me. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-17 : 23:34:13
|
| not possible to implement custom step sequence through standard sql agent job. we implement this by means of control table where we log status from each of job steps to it and can be used to check and execute required step------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
RE: SQL Server Job Issue