DSXchange

We have a server job which runs daily. Normally it takes approx 7 minutes to complete. But the yesterdays run of this job is still in running state. No warnings whatsoever. We are not accessing any Databases. Only seq files and hash files. All the files required are in place and have the proper rig...

you can use unix command to rename the file ( u can use this `date +"%Y%m%d%H%M%S"`), use the command in "after job subroutine " in the job properties.

Since you are using Oracle Stage, its doing Bulk load by using SQLLDR internally. You have to set an APT value for SQLLDR this by giving value (DIRECT=FALSE, PARALLEL=TRUE) and make the index option maintenance.

Pls let me know how it goes.

Create shell script(s) which calls the job(s) and keep that in cron.

regards
Kausik