I am looking for a breakdown of 3 fields in the CM database. So far I have
----------------------------------------------------------------------------------
STATUS
Y = OK
N = NOTOK
STATE
4 = RUNNING
1 = WAIT CONFIRM
AJFSONSTR
1st Position = Y = INPUT CONDITION
N = NO INPUT CONDITION
2nd Position = Y = YES OUT CONDITION
5th Position = Y = YES AUTOEDIT VARS
8th Position = STEPS ???
14th Position = NO SUBMIT TIME ??
----------------------------------------------------------------------------------
If anyone has more information please let me know. BMC will not help on this one.
Thank you -Goo
Database Content Definitions
KB article SLN000000165194 has the following lists. The article was published in 2003 for up to v6.4.01. It will be good to know what is in AJFSONSTR.
=============================
All the valid states used CONTROL-M/Server can be found below. Be aware that state definitions may change without notice. Use of these states are for reference only.
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 determines if the job is on hold. Possible values are:
N not on hold
Y on hold
D Job was deleted.
=============================
All the valid states used CONTROL-M/Server can be found below. Be aware that state definitions may change without notice. Use of these states are for reference only.
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 determines if the job is on hold. Possible values are:
N not on hold
Y on hold
D Job was deleted.
Thank you, it would be nice to know ajfsonstr also.
It appears that ajfsonstr is a series of Y and N switches. They appear to be indicators to the job. I got the above position indicators by trial and error. I guess thats what we will have to do.
Lets see if anyone else has any answers.
Thank you --Goo
It appears that ajfsonstr is a series of Y and N switches. They appear to be indicators to the job. I got the above position indicators by trial and error. I guess thats what we will have to do.
Lets see if anyone else has any answers.
Thank you --Goo
Here is what I have so far.
AJFSONSTR
1st Position = INPUT CONDITION EXIST
2nd Position = OUT CONDITION EXIST
5th Position = AUTOEDIT VARIABLES EXIST
6th Position = SYSOUT HANDLING
Y = COPY
N = NONE
7th Position = POST PROCESSING EXIST
8th Position = TASK TYPE
B = JOB
C = COMMAND
D = DETATCHED
9th
10th
11TH
12th
13TH
14th Position = DESCRIPTION
Y = EXIST
BLANK = NOT EXIST
AJFSONSTR
1st Position = INPUT CONDITION EXIST
2nd Position = OUT CONDITION EXIST
5th Position = AUTOEDIT VARIABLES EXIST
6th Position = SYSOUT HANDLING
Y = COPY
N = NONE
7th Position = POST PROCESSING EXIST
8th Position = TASK TYPE
B = JOB
C = COMMAND
D = DETATCHED
9th
10th
11TH
12th
13TH
14th Position = DESCRIPTION
Y = EXIST
BLANK = NOT EXIST
I did some modifications at active job to determine the meaning of the field.
1 IN condition
2 OUT condition
3 Control resource
4 Quantitative resource
5 AutoEdit variable
6 SYSOUT handling
7 Post Processing (Shout)
8 On-Do block
9 Do-Condition
10 Do-SetVar
11 Do-Notify
12 Do-Force
13 Do-SYSOUT
14 Active job modified
For each of positions 1 - 13, a 'Y' indicates the entity exists, otherwise an 'N'. For position 14, an 'N' indicates active job has been modified after order, otherwise a blank space.
The list is slightly different from yours. Do you find the same results?
1 IN condition
2 OUT condition
3 Control resource
4 Quantitative resource
5 AutoEdit variable
6 SYSOUT handling
7 Post Processing (Shout)
8 On-Do block
9 Do-Condition
10 Do-SetVar
11 Do-Notify
12 Do-Force
13 Do-SYSOUT
14 Active job modified
For each of positions 1 - 13, a 'Y' indicates the entity exists, otherwise an 'N'. For position 14, an 'N' indicates active job has been modified after order, otherwise a blank space.
The list is slightly different from yours. Do you find the same results?