Thank you very much for your help and advice.
-------------------------------------------
Original Message:
Sent: Aug 08, 2025 08:23 AM
From: Peter Grundler
Subject: C_Period definition
Hi Oscar,
for future executions you need to create a routine similar to forecast. I would avoid this and use the build in forecast functionality instead. Afterwards you can query the F* tables
reagards,
Peter
BTW: EPDC contains the calendar definition for a periodic run. As this is optional data, EPD is correct.
HAPPY National Day to my singaporean friends!
------------------------------
Automic Certified Professional/Expert & Broadcom Knight
Original Message:
Sent: Aug 07, 2025 12:44 PM
From: Oscar Leon
Subject: C_Period definition
Hi Peter and Daryl for your prompt response.
I'm trying to list future executions, not history. That's why I'm using OH.
As far as Peter's comment, I think you mean table EPDC, right? I cannot find EPC table
Thanks again to both of you for your help
Original Message:
Sent: Aug 07, 2025 12:36 PM
From: Daryl Brown
Subject: C_Period definition
If you're looking for data on the actual runs (as opposed to just the object definition data in the OH table), I would think you'd need to be looking in the AH and/or EH tables for those statistics.
This may be my confusion, though...
Are you trying to build a report of when everything is scheduled to run, or a report of when everything did run?
Original Message:
Sent: Aug 07, 2025 11:14 AM
From: Oscar Leon
Subject: C_Period definition
Hi, I am trying to create a report (SQL query), showing all jobplans executed on specific dates/times. I'm using OH and JPP tables, but I don't see any jobplans using C_Periods there, just schedules.
Can someone guide me on how to also show jobplans using C_Periods, not only schedules?
thanks in advance for any information you can share.
-------------------------------------------