Anyone know how to get a database job to run?

From: RMakanji <rmakanji_at_mindspring.com>
Date: Mon, 15 Mar 1999 09:34:27 -0600
Message-ID: <7cj61g$olg$1@samsara0.mindspring.com>

I can't get a database job to process. I use the code below to submit the job fine but it never runs. I assume its a problem with parameters. I've tried playing with the parameters but cannot use the Run(job) call to kick it off immediately for testing without getting errors.

What I want it to do is kick of tommorow morning at 5:00AM.

Declare

v_jobnum NUMBER;
BEGIN DBMS_JOB.SUBMIT(v_jobnum,'tax_interface.adp_quarterly(:p_qtr);',trunc(sysdat e)+29/24);

    commit;
EXCEPTION
    WHEN OTHERS THEN
        dbms_output.put_line('Error submitting job. '||SQLERRM); END; -- Procedure Received on Mon Mar 15 1999 - 09:34:27 CST