GEN productline query in ProcessFlow

Okay...

I just made it work:
PROD=GEN&FILE=QUEUEDJOB&FIELD=STATUS;JOBNAME;USERNAME&OUT=CSV&DELIM=~

I just need to determine the criteria for the pull.... and the various nodes.

This might be a good topic for tips and tricks. With an AGS, JOBRUN, AGS, BRANCH, EMAILS a processflow could be run to update a job like PA100, run the job, verify when done... and email someone. A more advanced use would be to loop the query on QUEUEDJOB until the job is complete and then run another job that relies on the completion of the first job...

(Does anyone know where I can get a list of the fields in the QUEUEDJOB table?)

Hi Shane,

The command 'dbdesc gen queuedjob' will give you a list of the fields, and cryptic information about each of them. The command 'prtdict gen queuedjob' will give you more information about how QUEUEDJOB is defined in the data dictionary, but it is not particularly easy to parse. I wrote a Java progam to read a Lawson data dictionary, so that I could get GEN information in a more readily understanable format. For QUEUEDJOB, it shows:

QUEUEDJOB

FIELD NAME DESCRIPTION

JobNumber ALPHA 10

UserName ALPHALC 10

JobName ALPHA 10

JobQueue ALPHA 10

Status BINARY 1

Type BINARY 1

SeqNumber NUMERIC 5

RstStepNbr NUMERIC 5

StartDate YYYYMMDD 8

StartTime TIME 6

ActStartDate YYYYMMDD 8

ActStartTime TIME 6

StopDate YYYYMMDD 8

StopTime TIME 6

ProductLine ALPHA 14

Token ALPHALC 10

Filler2 ALPHA 2

ProcessId BINARY 4

UserId BINARY 4

MachineName ALPHALC 10

QUEUEDJOB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION

QJBSET1 JobNumber keyChange

QJBSET10 StopDate* keyChange, Subset (COMPLETED)
StopTime* Where Status >= 060+
UserName AND Status <= 089+
JobName
JobNumber

QJBSET2 Status keyChange
JobNumber

QJBSET3 Status keyChange
JobQueue
SeqNumber
JobNumber

QJBSET4 JobQueue keyChange
Status
SeqNumber
JobNumber

QJBSET5 ProductLine keyChange
Token
Status
JobNumber

QJBSET6 UserName keyChange, Subset (ACTIVE)
ActStartDate Where Status >=
ActStartTime AND Status <= 029+
JobName
JobNumber

QJBSET7 JobQueue keyChange, Subset (ACTIVE)
ActStartDate Where Status >=
ActStartTime AND Status <= 029+
UserName
JobNumber

QJBSET8 UserName keyChange, Subset (WAITING)
ActStartDate Where Status >= 030+
ActStartTime AND Status <= 059+
JobName
JobNumber

QJBSET9 JobQueue keyChange, Subset (WAITING)
ActStartDate Where Status >= 030+
ActStartTime AND Status <= 059+
UserName
JobNumber

QJBSET911 UserName keyChange
JobName
Status
JobNumber

QJBSET912 UserName keyChange, Subset (COMPLETED)
StopDate* Where Status >= 060+
StopTime* AND Status <= 089+
JobName
JobNumber

I wouldn't use processflow for batch monitoring if it's terribly critical. I ended up writting my own batch monitor and paging system. Be happy to share it with anyone who would like it. Must be on UNIX/Oracle to work as I wrote it in oratcl. Also requires it's own Oracle tablespace to store info about users, jobs, etc. Uses sendmail to page but could use pretty much anything you like.

Sanford: I'd be interested in what you have got written.
Contact me at moellerg@genesishealth.com or here.