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.