Page 1 of 1

pre-setting warning limits

Posted: Sat May 21, 2005 5:20 am
by SWW
Hi all,

I have job that updates or inserts records into a table which is part of scheduled sequence. I expect there to be a lot of warning for failure to update records (that's normal for this job, there should not be a lot of updates). My problem is that this part of the sequence aborts because it exceeds 50 warnings. When I run this job manually, the default is unlimited warnings. How / Where do I preset the warning limit?

Thanks!

Steve

Posted: Sat May 21, 2005 6:59 am
by elavenil
The same topic covered few times in the forum. You can set warning limits while running the job , there is a limit tab where you can specify the warning limit or warning limits can be mentioned in Option menu item under tools menu in DataStage director.

Hope this would help.

Regards
Saravanan

Posted: Sat May 21, 2005 7:21 am
by SWW
Thanks,

I had the project preset at 50 warnings.

Steve

Posted: Sat May 21, 2005 1:19 pm
by dsdesigner
If you are running the job from the command prompt or a sheel script using the "dsjob" command, then you can set the warning limits for this job from the dsjob command iteself.

eg
dsjob -run -warn 10000 proect_name job_name

Posted: Sun May 22, 2005 12:04 am
by dsdesigner
I meant shell scripts