Is There any way to abort a job after 50 warnings

[nkln@you]

We are in need to abort a dimension job after 50 errors are thrown and abort a fact job if 1 error is thrown.

If we set the tracing properties in director, it will set to the whole project.


How can we apply individually this abort limit to a job.

[kumar_s]

Go to Tools-->Option-->Limits
Set the values as required for the individual jobs.

[nkln@you]

In 7.0 this option is not present

I went to Tools->Options , but could not find limits.

[kumar_s]

How you call the job, is it through the sequnce or from command prompt. If the job is been called from command prompt by dsjob command, you can make use of 'dsjob -run -warn # {job name}' property. You can provide the warning limit at the -warn parameter.

[nkln@you]

I am running the jobs through sequencer

[chulett]

That's fine... whatever Warning Limit is in effect for the 'parent' Sequence job itself will be passed to all 'child' jobs that it runs automatically.

[gateleys]

I need information as well. Can anybody please suggest a way to set number of warnings for individual jobs, rather than for all the jobs when using a sequence?

Thanks.
gateleys

[chulett]

If by that you mean running a series of jobs via a Sequencer and you want individual jobs to have different 'Abort after' warnings levels - you can't. That kind of thing would require custom job control code.

[gateleys]

OK, that would mean if the previous poster 'Aim High' were to set warning limit to 50 for his dimensions and 1 for the Fact, then he would need to have them in separate sequence. Am I right?

gateleys

[chulett]

Yes. Completely separate sequence jobs.

[nkln@you]

I am planning to force abort a job after 50 errors . Is this possible by writing a code in a job. i.e by capturing number of rejected rows and then force abort a job. How can i do this in a simple way. I need to incorporate this in so many jobs.

[vcannadevula]

I am planning to force abort a job after 50 errors . Is this possible by writing a code in a job. i.e by capturing number of rejected rows and then force abort a job. How can i do this in a simple way. I need to incorporate this in so many jobs.

Based on the number of reject rows you can abort by UtilityAborttoLog() routine.

If it is based on number of warning, when you start the sequecne set your warning limit to 50, datastage it self will abort the job after this.

[DSguru2B]

I dont think you can do that at the job level. Forcing a job to abort inside the job, never heard of it, and cant think of any way to do it.
As others have suggested, you can
a) Do it via sequencers or
b) By custom job routine.

Gurus, Can this be done by building a Batch job outof these jobs and in the job control,
add a code

Code: Select all

ErrCode = DSSetJobLimit(hJob3, DSJ.LIMITWARN, n)

where n = limit set.
???

[DSguru2B]

and hJob3 = My Job.
Forgot to add that in my previous post.

[chulett]

I dont think you can do that at the job level. Forcing a job to abort inside the job, never heard of it, and cant think of any way to do it.

It's a propery of every constraint. You can change the 'Abort after' value from zero rows (which means never) to a specific number - and when that many rows have gone down that link, the job will abort.