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!
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
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