Submit a job in DBMS_JOB

[230173]

Hi,

I'm trying to submit a job that has to be run every monday morning.

SQL> VARIABLE jobno number;
SQL> begin
2 DBMS_JOB.SUBMITjobno,
3 'CLEAN_SYNC_INF;',
4 SYSDATE, NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 8/24');
5 commit;
6 end;
7 /
ERROR:
ORA-01756: quoted string not properly terminated

Could anybody help me with this?

 

[stefanhei]

Line 4:
SYSDATE, 'NEXT_DAY(TRUNC(SYSDATE), ''MONDAY'') + 8/24');

Stefan

 

[230173]

Thanks