how can i abort the job if i get more than 100 errors in
job log?
- 6 Answers
- 22360 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the types of views in datastage director?
how to call sequential generator in datastage?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
count number of deptno in a emp table?
Can you define merge?
What is the purpose of pivot stage and types of containers in datastage
how to sort two columns in single job in datastage.
What is a merge?
sed,awk,head
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Teradata 
