Needs to create oracle jobs

See more:

SQL

SQL-Server

Oracle

Hey Guys i am trying to create an oracle job that runs on each monday at 7:00 am and i am trying to do it using the following query but it is giving me some errors.

What I have tried:

DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job => X
,what => 'BEGIN
analyze index HUAWEI_BSS6000.CELL6HO_EXT_DY_PK VALIDATE STRUCTURE;
analyze index HUAWEI_BSS6000.CELL6HO_INT_DY_PK VALIDATE STRUCTURE;
analyze index HUAWEI_BSS6000.CELL6_HO_OUT_DY_PK VALIDATE STRUCTURE;
analyze index HUAWEI_BSS6000.CELL6_INTERFER_DY_PK VALIDATE STRUCTURE;
analyze index HUAWEI_BSS6000.CELL6MAIN_DY_PK VALIDATE STRUCTURE;
COMMIT;
END;'
,next_date => to_date('06/27/2016 07:00:00','mm/dd/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+7)+7/24'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;

END;