I would like to set a job in the scheduler which will do a change of the resource manager plan.
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'scott.dayplan',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'dayplan'; END;'
start_date => '17-MAY-10 01.00.00 AM Europe/Warsaw',
repeat_interval => 'FREQ=DAILY; BYHOUR=8;',
end_date => '99-SEP-04 01.00.00 AM Europe/Warsaw',
comments => 'Resource manager daytime plan');
END;
/
But the job_action
is given wrong. Any ideas how to execute alter system command in create job function?