I have one job Batch that call other 5 jobs.
But sunddely one job finish (job status = finished) but the batch do not call the next job.
Or worse still, looking by DataStage Director Monitor all the stages have the Status = Finished but the job status do not update and stay the job and the batch with status = Running.
Somebody already had this problem?
Fernando Martins
Job Status Update
Moderators: chulett, rschirm, roy
-
fmartinsferreira
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
Hi,
there are several things to look for.
first of all you said batch job ther for I assume basic is the name of the game.
so you need to check why your code stopped.
there could be several reasons:
1. logic.
2. an error code or job status you didn't catch like the crashed status.
try checking the &PH& directory for this job run files (batch and all jobs run from it).
try checking all job logs for info.
if all seems fine try going over the logic around where you expected the next job to run and it didn't - check for any reason that will prevent it from running.
if nothing helps seek your support (if you didn't already)
IHTH & Good Luck,
there are several things to look for.
first of all you said batch job ther for I assume basic is the name of the game.
so you need to check why your code stopped.
there could be several reasons:
1. logic.
2. an error code or job status you didn't catch like the crashed status.
try checking the &PH& directory for this job run files (batch and all jobs run from it).
try checking all job logs for info.
if all seems fine try going over the logic around where you expected the next job to run and it didn't - check for any reason that will prevent it from running.
if nothing helps seek your support (if you didn't already)
IHTH & Good Luck,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
fmartinsferreira
- Participant
- Posts: 142
- Joined: Wed Mar 24, 2004 10:51 am
- Location: Brazil
Job Status Update
Well, I work remote.
My Server is in Mexico and I'm in Brazil.
Sometimes my connection go down and the jobs that were open, do locked. Then I enter in Director and open the Cleanup Resources option and gave a logout where is PHANTON.
When do not work I enter in Data Stage Administrator and execute the following comands:
1-I identify the number of job
=> SELECT * FROM DS_JOBS WHERE NAME LIKE 'ODSClien%'
Let's supose that job number is 10
2-Ask to clear the log and status
=> CLEAR.FILE DATA RT_LOG10
=> CLEAR.FILE DATA RT_STATUS10
Some time after the job is unlocked.
How about the PHANTON directory, generally I clean it once in a while using:
=> CLEAR.FILE &PHP&
And always that I clear the phanton I give a CLEANUP in my project.
well, I do this.
Could be this the problem?
Fernando Martins
My Server is in Mexico and I'm in Brazil.
Sometimes my connection go down and the jobs that were open, do locked. Then I enter in Director and open the Cleanup Resources option and gave a logout where is PHANTON.
When do not work I enter in Data Stage Administrator and execute the following comands:
1-I identify the number of job
=> SELECT * FROM DS_JOBS WHERE NAME LIKE 'ODSClien%'
Let's supose that job number is 10
2-Ask to clear the log and status
=> CLEAR.FILE DATA RT_LOG10
=> CLEAR.FILE DATA RT_STATUS10
Some time after the job is unlocked.
How about the PHANTON directory, generally I clean it once in a while using:
=> CLEAR.FILE &PHP&
And always that I clear the phanton I give a CLEANUP in my project.
well, I do this.
Could be this the problem?
Fernando Martins