problem with running job from TOAD
hi
I created a job to execute a stored procedure every day at midnight. this is the code
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'DBSCHEMA.PROCEDURE_NAME;'
,next_date => to_date('03/10/2008 12.50.00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1)'
,no_parse => TRUE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
END;
/
commit;
the procedure works and so does the job, when I run it immediately.
But the job doenst run at the expected time, and even if I run it manually, it just runs once.
is there some error in the parameters? maybe my schema has no rights to execute the job automatically? please help
thanks