• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Required 'Empty' Record in QUEUEDJOB?

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Kyle Jorgensen
Veteran Member Send Private Message
Posts: 122
Veteran Member
6/11/2013 2:40 PM
Is an 'empty' record required in the QUEUEDJOB table in GEN?

I'm creating a flow that will read this table and pro-actively notify users of jobs in their waiting queue.
While testing, I found that all 3 of our environments have an 'empty' record in this table.
That is to say the USERNAME, JOBNAME, TOKEN and PRODUCTLINE columns are spaces, the ACTSTARTDATE = '9999-08-03' and the ACTSTARTTIME = '12.34.56'.

The curious thing is that this EXACT record exists in all of our environments.

I was just going to ask our DBA to delete it, but since it's the same everywhere I thought I better ask this group if anyone else has a record like this in this table.  If so, maybe it's some sort of goofy 'required' record.
Kwane McNeal
Veteran Member Send Private Message
Posts: 479
Veteran Member
6/11/2013 2:47 PM
Kyle,
No. That record is the status '80' record. It's how lajs keeps track of the last job number. That record is required.
There should only be EXACTLY one 80 record.

Kwane
Kyle Jorgensen
Veteran Member Send Private Message
Posts: 122
Veteran Member
6/11/2013 5:22 PM
Awesome. I'll leave the record with status '80' alone!!