IPA Scheduler

 8 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Lynne
Veteran Member
Posts: 122
Veteran Member
    Does anyone know where to look in IPA to see all the scheduled PFs?  I have a 'My Scheduled Actions' that shows what I have scheduled.  I need to see anything scheduled by anyone like I can in the PF Designer's 'Scheduler'.  Thanks!
    Woozy
    Veteran Member
    Posts: 709
    Veteran Member
      You have to look in the AsyncActionRequest business class:

      Data Menu>>{prodline}>>async>>business classes>>AsyncActionRequest. Filter on Module=pfi, Class=PfiTrigger, and Action=Schedule.

      Kelly
      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      Dave Lis
      Advanced Member
      Posts: 24
      Advanced Member
        You can go to Process Server Configuration, click on the Menu tab and scroll down an look under Schedule heading.
        Bob Canham
        Veteran Member
        Posts: 217
        Veteran Member
          Thanks Kelly, that was really helpful. We hadn't been able to find this either so we created a service account to schedule our processes under.
          Lynne
          Veteran Member
          Posts: 122
          Veteran Member
            Thanks for your help, Woozy. I know wouldn't have gotten such a prompt response from support. I wish they had the name of the PF as one of the column headings. Do you know if that is customizable at all?
            Woozy
            Veteran Member
            Posts: 709
            Veteran Member

              Unfortunately, there is no relationship that includes the Pflow Name.  The closest I've been able to find is to look at the Action Parameters so you can get the Trigger Number and Work Title.

              If you have select access to the GEN tables, you can use the query below to get the details.  Hopefully this will help.

              select
                      aar.actor
                      ,aar.createdstamp
                      ,xml.PfiTrigger
                      ,coalesce(xml.PfiFlowName,'') as ProcessName
                      ,coalesce(xml.PfiServiceName,'') as ServiceName
                      ,xml.WorkTitle
              from
                      lmgen.asyncactionrequest aar
                      ,XMLTABLE(
                              '$p/view'
                              passing XMLPARSE(DOCUMENT(BLOB(AAR.ACTIONPARAMETERS))) as "p"
                              COLUMNS
                                      PfiTrigger integer path './fields/field[@name="PfiTrigger"]/text()'
                                      ,PfiFlowName varchar(20) path './fields/field[@name="FlowName"]/text()'
                                      ,PfiServiceName varchar(20) path './fields/field[@name="ServiceName"]/text()'
                                      ,WorkTitle varchar(40) path './fields/field[@name="WorkTitle"]/text()'
                              ) as xml

              where
                      aar.group='pfi'
                      and aar.implementingclass='PfiTrigger'

              Kelly Meade
              J. R. Simplot Company
              Boise, ID
              Woozy
              Veteran Member
              Posts: 709
              Veteran Member
                Dave Lis - All I find when I follow your suggestion are links to the Process Triggers and Service Triggers, but I don't see anyplace where I can see what is currently set up under the schedule. Am I just missing it?
                Kelly Meade
                J. R. Simplot Company
                Boise, ID
                Bob Canham
                Veteran Member
                Posts: 217
                Veteran Member
                  Using Woozy's instructions I was able to include the name by creating a report under the options menu. I had it filter to just show me the Scheduled items under my data area. Then I was able to personalize the columns to include the name and remove some other columns that I didn't care about. Created a canvas shortcut, and it is ready for me to get at quickly whenever I want.
                  Woozy
                  Veteran Member
                  Posts: 709
                  Veteran Member
                    Bob - that's a good option. The only issue is that it requires the person who scheduled the task to give it a meaningful name. If a small group of people are responsible for scheduling, then you could probably develop some sort of standard - we do this with Trigger WorkTitles.
                    Kelly Meade
                    J. R. Simplot Company
                    Boise, ID