schduelling disable trigger
446118May 17 2007 — edited May 17 2007how do i schduelle a job to disable trigger.
i tried the below but it won't work
var jobnumber NUMBER
BEGIN
DBMS_JOB.SUBMIT
(job => :jobnumber
,what => 'alter trigger atreport.at_postn disable;'
,next_date => trunc(sysdate+1)+ 4/24
,interval => '(sysdate+1/24)'
);
end;