begin
dbms_scheduler.create_job (
job_name=>'GATHER_SCOTT_STATS',
job_type=>'PLSQL_BLOCK',
job_action=>'DBMS_STATS.GATHER_SCHEMA_STATS(
ownname =>"SCOTT",
estimate_percent=>"DBMS_STATS.AUTO_SAMPLE_SIZE",
method_opt=>"FOR ALL COLUMNS SIZE AUTO",
cascade=>TRUE, DEGREE=>8)',
start_date=>systimestamp,
end_date=>null,
repeat_interval=>'FREQ=DAILY;BYHOUR=21;BYMINUTE=0;BYSECOND=0;',
comments=>'Job for gather statistics for SCOTT schema');
end;
/

BEGIN
  DBMS_SCHEDULER.RUN_JOB(
    JOB_NAME            => 'GATHER_SCOTT_STATS',
    USE_CURRENT_SESSION => TRUE);
END;
/

BEGIN
  DBMS_SCHEDULER.RUN_JOB(
    JOB_NAME            => 'GATHER_SCOTT_STATS',
    USE_CURRENT_SESSION => TRUE);
END;
Error at line 2
ORA-06550: line 5, column 27:
PLS-00103: Encountered the symbol "" when expecting one of the following:

   := . ( % ;
The symbol ";" was substituted for "" to continue.
ORA-06512: at "SYS.DBMS_ISCHED", line 196
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2

Script Terminated on line 125.