PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/25/2018 11:27 AM by  FireGeek21
PFI Schedule
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
FireGeek21
Private
Private
Veteran Member
(141 points)
Veteran Member
Posts:61


Send Message:

--
02/23/2018 9:44 AM

    What database/table is the PFI Schedule details stored in?  Looking to do a quick dump as a reference using SQL if possible but cannot seem to locate the table where this information is stored.

     

    Thanks!

    David Williams
    Private
    Private
    Veteran Member
    (3055 points)
    Veteran Member
    Posts:1029


    Send Message:

    --
    02/23/2018 9:57 AM
    Check the async - AsyncActionRequest Business Class
    David Williams
    Randy
    Systems Administrator
    Rochester Regional Health
    Veteran Member
    (101 points)
    Veteran Member
    Posts:37


    Send Message:

    --
    02/23/2018 10:06 AM

    Just did this a few weeks back

     

    -------------------------------------------------------------------------------------------------------------------------------------------------------------

    SELECT

    Case when Year(TIMETOEXEC) - YEAR(GETDATE()) > 0 then 'FALSE' else 'TRUE' end [RUNNING]

    ,NAME

    ,CREATEDSTAMP

    ,ACTOR

    ,AUTHENTICATEDACTOR

    ,EMAILADDRESS

    ,NOTIFICATIONTYPE

    ,DATAAREA

    ,TIMETOEXEC

    ,PENDINGSCHEDULING

    ,MISFIRETHRESHOLD

    --,MISFIRESTRATEGY

    --,MISFIREREPORTMODE

    ,CONTINUEONMISFIRE

    ,NOOFRETRIES

    -- ,ACTIONTYPE

    ,ISSCHEDULED

    ,SCHEDULEYEAR

    ,SCHEDULEMONTH

    ,SCHEDULEDAY

    ,SCHEDULEWEEKDAY

    ,SCHEDULEHOUR

    ,SCHEDULEMINUTE

    ,SCHEDULECONCURRENCY

    ,SCHEDULEFREQUENCYSECONDS

    FROM LMKGEN.LMKGEN.ASYNCACTIONREQUEST

    Where ASYNCACTION = 'Schedule'

    And PENDINGSCHEDULING = 1

    Order By 1,2

     

     

     

     

    Dave Lis
    Assistant Director - ERP
    Atlanta Public Schools
    Advanced Member
    (62 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    02/23/2018 10:45 AM
    Perfect!!  Thank you.
    FireGeek21
    Private
    Private
    Veteran Member
    (141 points)
    Veteran Member
    Posts:61


    Send Message:

    --
    02/25/2018 11:27 AM

    This solution is for when using Landmark.  We are looking for the schedules from PFI - pre Landmark.  We do have to rebuild them in Landmark but need to access the schedules from PFI.

     

    THANKS

    FireGeek21
    Private
    Private
    Veteran Member
    (141 points)
    Veteran Member
    Posts:61


    Send Message:

    --
    02/25/2018 11:27 AM

    This solution is for when using Landmark.  We are looking for the schedules from PFI - pre Landmark.  We do have to rebuild them in Landmark but need to access the schedules from PFI.

     

    THANKS

    You are not authorized to post a reply.