IPA Scheduler

 8 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Lynne
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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