Hi
I have a master sequencer which calls five jobs in a sequential order.
While running the master sequencer, i have given 50 warnings limit...which defaultly applies to all of the five called jobs.
But, I would like to override this 50 warning limit with a 100 warning limit for only one job out of five called jobs whenever there is a master sequence runs with 50 warning limit globally.
Is it possible to do this in DataStage?
Thanks
Sai
Setting warning limit override at job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
You can use a job control to launch your jobs, using the following :
...
NumberWarnings=50
NbWarnings = DSSetJobLimit(JobHandle, DSJ.LIMITWARN, NumberWarnings)
ErrExec = DSRunJob(JobHandle, DSJ.RUNNORMAL)
...
to parameter the abort of jobs after warnings.
Pierre.
...
NumberWarnings=50
NbWarnings = DSSetJobLimit(JobHandle, DSJ.LIMITWARN, NumberWarnings)
ErrExec = DSRunJob(JobHandle, DSJ.RUNNORMAL)
...
to parameter the abort of jobs after warnings.
Pierre.
Felix qui potuit rerum cognoscere causas. Virgile (Géorgiques).
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
Why not fix the job so that it doesn't generate warnings?
I'm firmly in the camp that believes the warning limit should be 1. In my opinion, using the default warning limit of 50 is just lazy programming/design.
And it's downright dangerous... what if you get a warning that actually requires you to take some corrective action to avoid corrupting your data warehouse? If you allow any warnings, there's a good possibility that you're going to miss the important ones.
Mike
I'm firmly in the camp that believes the warning limit should be 1. In my opinion, using the default warning limit of 50 is just lazy programming/design.
And it's downright dangerous... what if you get a warning that actually requires you to take some corrective action to avoid corrupting your data warehouse? If you allow any warnings, there's a good possibility that you're going to miss the important ones.
Mike
Mike is right, but sometimes we receive files with special characters which have to be rejected.
I sometimes use jobs with no limits (only during the running time) with a reject file to store the warnings, so I can run the job and treat the rejects later.
Pierre.
I sometimes use jobs with no limits (only during the running time) with a reject file to store the warnings, so I can run the job and treat the rejects later.
Pierre.
Felix qui potuit rerum cognoscere causas. Virgile (Géorgiques).