It is currently 22 Oct 2017 1:43


Post new topic  Reply to topic  [ 6 posts ] 
Author Message
PostPosted: 20 Jun 2013 5:23 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Sep 2010 12:00
Posts: 73
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


Top
   
 Post subject:
PostPosted: 20 Jun 2013 6:28 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Jun 2007 12:00
Posts: 317
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.


Top
   
 Post subject:
PostPosted: 20 Jun 2013 7:56 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Sep 2010 12:00
Posts: 73
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


Top
   
 Post subject:
PostPosted: 20 Jun 2013 11:07 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Sep 2010 12:00
Posts: 73
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


Top
   
 Post subject:
PostPosted: 21 Jun 2013 5:47 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Jun 2007 12:00
Posts: 317
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?


Top
   
 Post subject:
PostPosted: 21 Jun 2013 5:52 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Sep 2010 12:00
Posts: 73
Very cool!!!

It looks very close, but I have to change channels now for awhile before I get back to this.

Thanks again,

-Goo


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 6 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved