GenProcID of dbqueue started from a Schedule

Question

Hi, 
 I have a process that calls the StartNow method of a schedule to trigger recalculation of specific company policies whenever I like rather than at regular intervals. 
 I'd like to know when the company policies have finished before starting other jobs. 
 I thought I could do this in my process by checking the DBQueue for POL-K-QERPolicyFill tasks with the specific GenProcID, but I've not found a way to return the correct GenProcID. 
 Is this possible? Any thoughts/advice would be appreciated. 
 Craig

Barry Jackson · Answer

Hi Craig, 
 What version are we talking about? I'm going to assume > 8.0. 
 I'm guessing that you are looking for the genprocid of the generating process in either DialogDBQueue or QBMDBQueueCurrent? I wonder if the StartNow method is spawning something new so the dbq tasks get a new GenProcID? I'm guessing you are using StartNow to fire the policies that are grouped by that schedule? 
 Anyhoo ...... I wonder if it would work better for you to use the method RecalculatePolicy on the table QERPolicy with a well-defined WhereClause? Perhaps this will generate POL-K-QERPolicyFill tasks with the same GenProcID? You could group the policies by policy group rather than by schedule (or by compliance framework). 
 Does that help? 
 B.

Barry Jackson · Answer

Hi Craig, 
 I tested my theory and it seems not to work either. The process and the dbq job have different GenProcID's :-( 
 The only thing I can suggest is that you test for the presence of those tasks with the object = uid_qerpolicy for dialogdbqueue and the uid_parameter = uid_qerpolicy for qbmdbqueuecurrent. 
 HTH, B.

craigehunter · Answer

Thanks Barry.