Error in DBMS_JOB.SUBMIT

[ales]

Because you are only allowed to use PL/SQL code for a job.
Here you're trying to invoke a SQL*Plus script and the parser doesn't recognize the 'E:\ ... ' as a valid PL/SQL block.

In addition to that:

* You have to use either an SQL*Plus bind variable or a PL/SQL variable. Here you declare PL/SQL variable JobNo and use SQL*Plus bind variable. If you want to print jobno in this way you have to use bind variable.

* You have to COMMIT after dbms_job.submit.

variable JobNo number
begin
  DBMS_JOB.SUBMIT(:JobNo, 
  'BEGIN pl_sql_code; END;', 
  SysDate, 
  'SysDate + 1/24'); 
  commit;
end;
/
print JobNo