VARIABLE jobno NUMBER
BEGIN
DBMS_JOB.SUBMIT(:jobno,
‘DBMS_DDL.ANALYZE_OBJECT(”TABLE”,
”HR”, ”EMPLOYEES”,
”ESTIMATE”, NULL, 50);’,
SYSDATE, ‘SYSDATE + 1’);
COMMIT;
END;
/
PRINT jobno
JOBNO
———-
14144