Hi friends,

I have never used dbms_job before and need some advice on how to add a new job to run every 2 weeks.

I want to use dbms_job to analayse a schema at 10pm every 2 weeks. The sql is as follows :

EXECUTE SYS.DBMS_UTILITY.ANALYZE_SCHEMA('USERNAME','COMPUTE');

Can someone please supply syntax.

Thanks.