how can i abort the job if i get more than 100 errors in
job log?
Answers were Sorted based on User's Feedback
Answer / jaimy chacko
Compile the job and then run it- in the Job run option select the "Abort Job after" and give 100. So if there is 100 warnings(errors) the job will be aborted.
Is This Answer Correct ? | 24 Yes | 2 No |
In the designer, After Compiling the job and then click on
run.in the Job run options, u will find 3 TABs :Parameters,
Limits, General. Go to Limits TAB, select the "Abort Job
after" and change it to 100. after 100 warnings(errors) the
job will be aborted.
by default it will set to 50
warnings.
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / xxx
by default it will set if job has more than 50
warningd,then job will abort.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / satya
U can use UtilityAbortToLog() function in transformer to
abort the job.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / bietl
Hi,
You can use the Transformer stage,we have an option called
abort rows just mention the value it will abort once it
reach that count.
hope this will help you..
Is This Answer Correct ? | 3 Yes | 13 No |
how to convert rows into columns
how to abort the job its matain duplicates?
Can we use target hash file as a lookup ?
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
How can we run same job in 1 day 2 times
How to delete the data in dataset?types of deleting the data in dataset?
What is oci?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
What are the repository tables in datastage?
client know skid info?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,