你试试这个

DROP TABLE TABLE1;
CREATE TABLE TABLE1(ID INT IDENTITY(1,1) PRIMARY KEY,DD DATETIME)

CREATE OR REPLACE TRIGGER timer2
AFTER TIMER on database
for each 1 day for each 1 minute
BEGIN
delete from TABLE1;
insert into table1(DD) VALUES(SYSDATE);
COMMIT;
END;
/