• State Suggested Answer
  • Replies 3 replies
  • Answers 3 answers
  • Subscribers 95 subscribers
  • Views 2451 views
  • Users 0 members are here
Options
Related

GenProcID of dbqueue started from a Schedule

craigehunter
over 3 years ago

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

Parents
  • 0 over 3 years ago

    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.

Reply
  • 0 over 3 years ago

    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.

Children
No Data