删除其他用户的JOB

Begin
For v In (Select Job From Dba_Jobs Where Log_User <> ‘SYS’) Loop
Dbms_Ijob.Remove(v.Job);
End Loop;
Commit;
End;

修改下一次启动时间

Begin
Dbms_Ijob.Next_Date(‘3’, Sysdate + 2 / 48);
Commit;
End;