dbms_job.submit giving me error

[slash]

Hi gram2000,

You need to add a semi colon after the call to the procedure in the dbms_job package.

Try this
exec dbms_job.submit(:n1, 'LMT_Gather_Ts_Data;', sysdate, 'sysdate + 1');

Cheers
Slash