Use dbms_scheduler to gather multiple schema stats

Hello All,

I am trying to schedule a job using dbms_scheduler which can collect statistics on specific schemas using custom parameters.

I want to use the default maintainence window timings used by  'auto optimizer stats collection' i.e  mon- fri :10pm and sat,sun :6am. So i used schedule_name as 'ORA$AT_WGRP_OS'(window group used by auto stats job).

This is my first time creating a dbms_scheduler job.

Please let me know for any changes/recommmendations needed.

begin

dbms_scheduler.create_job(

job_name => 'GATHER_VENDOR_SCHEMA_STATS_JOB',

job_type => 'PLSQL_BLOCK',

job_action => 'DECLARE