Sample Header Ad - 728x90

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