How to Alter the Job
You can alter the job's attributes, for example, change the time when it runs to every Saturday, 6 PM:
Log in to your schema with the Codebeamer Oracle account
Run the following script to change the job's appropriate attributes :
BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE (
name => 'GATHER_MANUAL_STATS_FOR_USER',
attribute => 'repeat_interval',
value => 'Freq=Weekly;ByDay=Sat;ByHour=18');
END;
/
Was this helpful?