Jobs will not run

From: Ronald <ronald_at_nowhere.com>
Date: Sat, 1 Jun 2002 12:21:30 +0200
Message-ID: <ada77g$v42tj$1@ID-87429.news.dfncis.de>

What could be the possible cause of DBMS_JOB job not being run?

My job will not run, although it's submitted OK. I can see it in USER_JOBS, but it's simply not being triggered.

(Now it's 28 hours since NEXT_DATE
in USER_JOBS for this job. Of course, LAST_DATE is still NULL.)

Command, as entered in SQL*Plus:

    VARIABLE jobno NUMBER;
    BEGIN
        DBMS_JOB.SUBMIT(:jobno, 'my_proc(sysdate);', SYSDATE+3/1440, 'SYSDATE+12/1440');
        COMMIT;
    END; Is there some gotcha?

Platform is 8.1.6 on Windows. Received on Sat Jun 01 2002 - 05:21:30 CDT