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
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
    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
      Posts: 122
      Veteran Member
      6/11/2013 5:22 PM
        Awesome. I'll leave the record with status '80' alone!!