After Job Subroutine executing before the job completes
Posted: Wed Sep 21, 2011 4:58 am
Hello,
We are facing an issue where in after job subroutine script is getting executed before job completion.
The job creates a header, detail and trailer and there is a DOS script called in after job subroutine to concat all three.
There has been 2-3 instances when the file only contained Header and Trailer. In this case the log file had info in the after job subroutine below the detail file name in ***Output From Command**** that -
"The process cannot access the file because it is being used by another process."
Hence we doubt that the detail file creation was still happening and the DOS script was fired hence the issue.
The settings in general tab of job proporties were:
Only run after-job subroutine has successfully completed
and
Enabled Hash File Cashing
The performance tab has 'Enable Row Buffer'->'Inter Process' been selected.
Anyone can suggest why is this happening.
We are facing an issue where in after job subroutine script is getting executed before job completion.
The job creates a header, detail and trailer and there is a DOS script called in after job subroutine to concat all three.
There has been 2-3 instances when the file only contained Header and Trailer. In this case the log file had info in the after job subroutine below the detail file name in ***Output From Command**** that -
"The process cannot access the file because it is being used by another process."
Hence we doubt that the detail file creation was still happening and the DOS script was fired hence the issue.
The settings in general tab of job proporties were:
Only run after-job subroutine has successfully completed
and
Enabled Hash File Cashing
The performance tab has 'Enable Row Buffer'->'Inter Process' been selected.
Anyone can suggest why is this happening.