SQL> select job from dba_jobs_running;

no rows selected

SQL> select THIS_DATE,THIS_SEC,NEXT_DATE, NEXT_SEC,INTERVAL from user_jobs where job=44;

THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC
--------- -------- --------- --------
INTERVAL
--------------------------------------------------------------------------------
09-JUL-02 07:47:54
NEXT_DAY(TRUNC(SYSDATE),'SUNDAY')+3/24

Jurij,
now my job is not running it seems, atleast now, it has to show me the next sunday's date. but here it's not. And i gone throught the complete procedure there is no exceptions which are unhandled. What might be the problem??