When adding multiple attributes, try:
DBMS_SCHEDULER.set_attribute(
name => 'first_job',
attribute => 'raise_events',
value => DBMS_SCHEDULER.job_succeeded + DBMS_SCHEDULER.some_attribute);
The valid values for event types (11gr2) is here. And according to docs, job_over_max_dur is enabled already for 11gr2.
Now, for 10g or 11gr1, I don't see job_over_max_dur in the list of event types raised by the scheduler. But you mentioned in earlier post that you will very soon migrate to 11gr2, so I assume you have a test box setup already that you can test this with 11gr2. If you really want to go down the rabbit hole with AQ, you can do more custom events, but it would probably be much easier to wait a bit until you're on 11gr2.
Edit
To add more info, first some basic scheduler stuff you can view to see whats running (or scheduled, or stalled, or whatever state):
select * from dba_scheduler_jobs
where owner = 'SOME_OWNER'
and job_name = 'SOME_JOB';
You can see if max_run_duration column is set and also the "raise_events" column will show a list of event types that are to be raised by each job. You should see "JOB_OVER_MAX_DUR" type here.
If you want to test if your db environment is handling the JOB_OVER_MAX_DUR properly, then you can setup a quick test:
BEGIN
-- setup simple scheduler job
--DBMS_SCHEDULER.DROP_JOB('EVENT_RAISING_JOB',false);
DBMS_SCHEDULER.create_job (
job_name => 'EVENT_RAISING_JOB',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN
dbms_lock.sleep(70);
END;',
start_date => SYSTIMESTAMP,
end_date => SYSTIMESTAMP + 2, -- 2 day
repeat_interval => 'freq=daily; byhour=1',
enabled => TRUE);
DBMS_SCHEDULER.set_attribute(name=>'event_raising_job', attribute=>'max_run_duration', value=>interval '60' second);
DBMS_SCHEDULER.set_attribute(name => 'event_raising_job', attribute => 'raise_events',value => DBMS_SCHEDULER.job_all_events );
END;
-- setup email notification
exec dbms_scheduler.add_job_email_notification( job_name=>'EVENT_RAISING_JOB',recipients=>'someuser@somedomain.com', events=>'job_all_events');
-- launch job
exec dbms_scheduler.run_job('EVENT_RAISING_JOB',false);
You should get 3 emails that this job: STARTED, SUCCEEDED, and JOB_OVER_MAX_DUR
Best Answer
Have a look at the TIMESTAMP column of the ALL_TAB_MODIFICATIONS. http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2097.htm
Also, keep in mind this part: