couple of problems.
eforms_own? sys owns dbms_scheduler
start_date => 'trunc(sysdate+1/7/24'?? missing closing parenthesis and I think you meant 7am, which would be trunc(sysdate)+7/24
ops$tkyte%ORA10GR2> select trunc(sysdate)+1/7/24, trunc(sysdate)+7/24 from dual;
TRUNC(SYSDATE)+1/7/2 TRUNC(SYSDATE)+7/24
-------------------- --------------------
30-nov-2009 00:08:34 30-nov-2009 07:00:00
you are missing the end; statement for the block... and also, start_date is of type timestamp, NOT varchar2, you do not pass a string - unless that string is a timestamp to be converted with your default NLS settings..
you never got to the repeat interval bit... however:
ops$tkyte%ORA10GR2> BEGIN
2 DBMS_SCHEDULER.CREATE_JOB
3 ( job_name => 'MESSAGE',
4 job_type => 'PLSQL_BLOCK',
5 job_action => 'P',
6 start_date => trunc(sysdate)+7/24,
7 repeat_interval => 'FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN; BYHOUR=7,8,9,10,11,12,13,14,15,16,17,18,19;',
8 enabled => FALSE,
9 comments => 'Every hour'
10 );
11 end;
12 /
PL/SQL procedure successfully completed.