Page 1 of 1

Dont want to abort after 50 rows

Posted: Mon Jun 29, 2015 4:43 am
by SURA
Hello All

I am using a multiple instance server job to load the data.

As per the present need i don't want the job to abort even if the records has been rejected.

If i run the job manually, i can change the Warning Limits whereas when the job has been triggered Master Sequence how to chance it to "No Limit"?

Posted: Mon Jun 29, 2015 5:36 am
by ShaneMuir
So a job would normally inherit the limit value from the controlling sequence, are you saying you do not want this to happen - ie for a particular job you want to override the limit warning?

Posted: Mon Jun 29, 2015 4:26 pm
by SURA
Yes.

As per the design this is the only place where job can run no matter what? Rest of the designs are made to trigger the Abort process.

Posted: Mon Jun 29, 2015 5:57 pm
by SURA
-warn n should work i believe.

In this situation, a sequence is triggering the job, but i am using dsjob to trigger the sequence.

I am not sure -warn n to sequence will reflect to this job?

Let me try!

If you guys have any idea, please share with me.

Posted: Mon Jun 29, 2015 8:06 pm
by SURA
- warn 0 worked.

Thanks to all.