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 |
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
Tell me the syntax of Configuration file?
Explain how a source file is populated?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
Notification Activity
can we use sequential file as a lookup
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How to move data set from one server to other?what are the steps to follow to do this?
In Datastage, how you can fix the truncated data error?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
if ename='subbu' while running job the job should be abort how come?