MAM 7.6.1.2:Is there a way to use an escalation/action to truncate and reload a custom table? (on a nightly schedule)
I would populate the table with the rows from a SQL query (a query that rolls up tasks to WOs). The idea being, a static table that is refreshed nightly would be faster/less load on the system -- compared to constantly calculating rows on-the-fly in a db view (real-time data isn't needed). And the custom related table avoids the need to add 10+ fields to the WORKORDER table...which already has too many fields (250+ OOB fields).
I would prefer to do this from inside Maximo, rather than do it directly in the database via Oracle Scheduler.
I've tried creating a custom action. But I don't see any options that would let me batch delete and insert records.
Thanks.
#Administration------------------------------
User 1972
NA
------------------------------