Hi

I hv submitted a job like this to execute it everyday at 7.00AM.


create or replace procedure DBMS_HOLIDAY_JOB
as
jobHoliday number;
begin
dbms_job.submit(
jobHoliday, 'HolidayAssign.checkHoliday;',
trunc(sysdate)+7/24,
'SYSDATE+1');
commit;
end;
/

exec DBMS_HOLIDAY_JOB;


But it was not executed at 7.00am...what cud be the pbms....any solutions or change in teh script?

Here HolidayAssign is a package and checkHoliday is a procedure. My environment is windows NT and Oracle 9.2.0

In init.ora file parameters are

JOB_QUEUE_PROCESSES=10