Hi All,
Hope everyone is doing good..
One of jobs are going to blue state (i.e. waiting for resource) once its time frame is reached... Doing why it shows " performing why on job"..
It's seems a something peculiar things.. As the agent is up and fine and no resources allocated.
Please help us to find, where would be the exact problem?
*****Job turns to blue***
Hi,
There are times when a Job for whatever reason, does not release the Control Resource or Quantitative Resource after it has finished.
This prevents other jobs that require the same Control/Quantitative Resource from Executing because the Resource will never be freed without a manual Database update.
In the Bmc KB a procedure is detailed:
- See SLN000000175228 for Control Resource
- See SLN000000196208 for Quantitative Resource
In this forum you can see this post too.
There are times when a Job for whatever reason, does not release the Control Resource or Quantitative Resource after it has finished.
This prevents other jobs that require the same Control/Quantitative Resource from Executing because the Resource will never be freed without a manual Database update.
In the Bmc KB a procedure is detailed:
- See SLN000000175228 for Control Resource
- See SLN000000196208 for Quantitative Resource
In this forum you can see this post too.
Best regards
Walty
Walty
Hi,
Some suggestions.
Analyse steps:
- Look the status of job by the utility <ctmpsm> to see whether you have the same situation.
ie: if Unix agent use : ctmpsm -LISTALL JOBNAME | grep <your_jobname>
- Check status of job by SQL query:
select JOBNO, JOBNAME, MEMNAME, HOLDFLAG, STATUS, STATE from CMR_AJF where JOBNAME='your_jobname'
All the valid states used by CONTROL-M/Server
STATE:
0 Wait for Scheduling Criteria to be evaluated
1 Wait for Confirmation from user
2 Submitted to Agent
3 Not submitted to Agent
4 Executing
5 Ended
6 Analyzed Post Processing Steps
7 Disappeared
8 Post Processed
9 Not Found
A Waiting to Rerun
B Waiting for From Time
C Wait for In Condition
D Wait for Resource
E Wait for Submission
F Not used by CONTROL-M/Server
G Retry Submission to Agent
H Wait for Group Scheduling
I Failed To Submit
J Job waiting for Odate
K Job is past its Odate
Z Agent Status is Unknown
STATUS:
Y means that the job has completed successfully.
N means that he has not completed or it has completed unsuccessfully.
HOLDFLAG:
N not on hold
Y on hold
D Job was deleted.
Debugging steps:
- Try execute a <Force-Ok> to terminate this job
or
- Hold this job
- Update status by SQL query:
update CMR_AJF set STATUS='N', STATE='5, OSCOMPSTAT='1'' where JOBNO='your JOBNO'
- Free your job. It will appear in Red now.
Some suggestions.
Analyse steps:
- Look the status of job by the utility <ctmpsm> to see whether you have the same situation.
ie: if Unix agent use : ctmpsm -LISTALL JOBNAME | grep <your_jobname>
- Check status of job by SQL query:
select JOBNO, JOBNAME, MEMNAME, HOLDFLAG, STATUS, STATE from CMR_AJF where JOBNAME='your_jobname'
All the valid states used by CONTROL-M/Server
STATE:
0 Wait for Scheduling Criteria to be evaluated
1 Wait for Confirmation from user
2 Submitted to Agent
3 Not submitted to Agent
4 Executing
5 Ended
6 Analyzed Post Processing Steps
7 Disappeared
8 Post Processed
9 Not Found
A Waiting to Rerun
B Waiting for From Time
C Wait for In Condition
D Wait for Resource
E Wait for Submission
F Not used by CONTROL-M/Server
G Retry Submission to Agent
H Wait for Group Scheduling
I Failed To Submit
J Job waiting for Odate
K Job is past its Odate
Z Agent Status is Unknown
STATUS:
Y means that the job has completed successfully.
N means that he has not completed or it has completed unsuccessfully.
HOLDFLAG:
N not on hold
Y on hold
D Job was deleted.
Debugging steps:
- Try execute a <Force-Ok> to terminate this job
or
- Hold this job
- Update status by SQL query:
update CMR_AJF set STATUS='N', STATE='5, OSCOMPSTAT='1'' where JOBNO='your JOBNO'
- Free your job. It will appear in Red now.
Best regards
Walty
Walty