How to auto run oracle stored procedure
-2
votes
1
answer
1115
views
Is there any possibility to auto run procedure after a specific time/date?
For example I want to auto run this stored procedure after 2 days:
CREATE OR REPLACE PROCEDURE deleteresetlinks
AS BEGIN
DELETE FROM passwordresetlink WHERE date_created <= TRUNC(SYSDATE) - 3;
END;
Asked by user230
(1 rep)
Jun 15, 2021, 07:00 AM
Last activity: Jun 20, 2021, 11:00 AM
Last activity: Jun 20, 2021, 11:00 AM