DSXchange

If i understood correctly, are you asking me use Unix Scheduler instead of scheduling at Director ? What if i need to call the sequencer repeatedly. It might lead on writing some more jobs as a cover. Else i can give other scenario, I have a Job sequence which calls 20 Jobs. Assuming one of the job ...

Thanks for your suggestion Kumar. First I tried that option and resulted the same issue.

You might be right, But we need to think about restart option aswell. In real scenario, sometimes all tables except one might have gone fine. When you are re-executing, it might be difficult to clean-up the old records and some manual process are required. To avoid that he can go ahead with 6 jobs. ...

Yes guru. You understood correctly.

It's again depends on how Database and network servers are configured as well with number of CPU's (Environment) probably he can do a POC and go ahead based on that.

Is that job still running? If so, stop the job and make sure with your DBA that the table has not locked. Hope you are using OCI stage to insert the data. If so, What is the write method and Upsert Mode?. Instead of Auto genearated, use the User-Defined update Only option and write the user defined ...

Is it direct load from Staging to all 6 tables or are you doing any transformations in middle. If there are no transformations in between, use 6 select reads and insert into tables. Do it parralelly so that the performance might increase if DB doesn't have bottleneck. My suggestion is write 6 differ...

Hi Ray, One request, if you don't like the way statements are constructed please mention those but don't mention your own understandings like "Hydrabad is souther half of india" which results the users feel badly. Moreover English is common language and every one might have their own style...

I did search on -03113 , result was my message nothing else.

I searched for the key but i didn't get any result.

Exactly, As DSGuru mentioned, Shell are called for some other purpose not to control jobs. Else it will be difficult to control jobs

I tried as Kumar mention, still having the same issue.

Yes.that's only that command..

Please let me know the solution if someone knows.

It's available, I could able to execute thorugh shell script for the same user.