Job Sequence running forever
Posted: Thu Dec 08, 2005 9:17 am
Hi,
I am using DS7.1 with Oracle9i. I have a job sequence that is running for a very long time. I realized that there was a query problem in one of the activities. So, I stopped the sequence, rectified the query.
My first question is- If I run the job sequence again, will it start all over again from the beginning, or from the job where it failed? Note: the previous job activities commit the transactions.
Second question- I read throught the forums, and found suggestions on restartability. I looked up the job properties for the sequence and found no such options. How would I force DS to restart from the point fo failure and not all over again?
I am using DS7.1 with Oracle9i. I have a job sequence that is running for a very long time. I realized that there was a query problem in one of the activities. So, I stopped the sequence, rectified the query.
My first question is- If I run the job sequence again, will it start all over again from the beginning, or from the job where it failed? Note: the previous job activities commit the transactions.
Second question- I read throught the forums, and found suggestions on restartability. I looked up the job properties for the sequence and found no such options. How would I force DS to restart from the point fo failure and not all over again?