GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 369 of 377    Print  
Sequencer Scenario
scenario- if suppose we have 3 jobs in sequencer, while running if job1 is failed then we have to run job2 and job 3 ,how we can run? plz ans this

thanks in advance



  
Total Answers and Comments: 5 Last Update: September 02, 2008     Asked by: pavan.daddanalla 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: ritu singhai
 

To run a job even if its previous job in the sequence is failed you need to go to the TRIGGER tab of that particular job activity in the sequence itself.
There you will find three fields:
Name: This is the name of the next link (link goin to the next job, e.g. for job activity 1 link name will be the link goin to job activity 2).
Expression Type: This will allow you to trigger your next job activity based on the status you want. For example, if in case job 1 fails and you want to run the job 2 and job 3 then go to trigger properties of the job 1 and select expression type as "Failed - (Conditional)". This way you can run your job 2 even if your job 1 is aborted. There are many other options available.
Expression: This is editable for some options. Like for expression type "Failed" you can not change this field.
I think this will solve your problem.



Above answer was rated as good by the following members:
Brajesh Singh Bhadoriya
July 05, 2008 07:10:04   #1  
ritu singhai Member Since: July 2008   Contribution: 3    

RE: Sequencer Scenario

To run a job even if its previous job in the sequence is failed you need to go to the TRIGGER tab of that particular job activity in the sequence itself.
There you will find three fields:
Name: This is the name of the next link (link goin to the next job, e.g. for job activity 1 link name will be the link goin to job activity 2).
Expression Type: This will allow you to trigger your next job activity based on the status you want. For example, if in case job 1 fails and you want to run the job 2 and job 3 then go to trigger properties of the job 1 and select expression type as "Failed - (Conditional)". This way you can run your job 2 even if your job 1 is aborted. There are many other options available.
Expression: This is editable for some options. Like for expression type "Failed" you can not change this field.
I think this will solve your problem.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
July 10, 2008 07:26:19   #2  
tina123 Member Since: July 2008   Contribution: 3    

RE: Sequencer Scenario
There are two possibilities,
1. The sequencer calls all the jobs in parallel
2. The sequencer calls all the jobs in serial
Parralel:
In this case even if one or two jobs fails the others will run (If u r using terminator activity then you have to select abort without sending STOP requests option)
Serail:
Select 'unconditional' in triggers which would call the next job unconditionally(even the first job completes or not).

If we select failed conditional in the trigger tab, the next job will be triggered only if the first job fails.

 
Is this answer useful? Yes | No
July 24, 2008 04:21:19   #3  
sankarganeshvel Member Since: May 2008   Contribution: 4    

RE: Sequencer Scenario
hi when u click on the sequencer
right click->prpperties->trigger->select unconditional
then even if the 1job fails or pass it go to second

 
Is this answer useful? Yes | No
September 02, 2008 05:17:45   #4  
mohd.shakeel Member Since: September 2008   Contribution: 2    

RE: Sequencer Scenario
First you login in as adminstrator
In adminstrator select Sequencer
In Sequencer on option is there check list on sequence fail, if you click on this option you will get your requirement.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape