Scheduling a SQL Script Job using OEM
Hello
We are trying to schedule a sql script job on our 13.5 for our 19c database
The idea is to find sessions with last_call_et 30 and status='ACTIVE'
select sql_id,inst_id,sid from gv$session where last_call_et 60 and status='ACTIVE';
We need this to run every 5 minutes and if it the rows returned are greater than zero, email us with the details
We were able to create a job and test it
We have 2 questions
- How to edit the job so that we can modify the script? When we highlight the job and edit and then click on parameters, the SQL Script is greyed out. We wanted to make some changes to the criteria and the columns returned from the query but it is greyed out. Why we cannot change the contents of the script? it seems until we have the job scheduled to run periodically we wont be able to edit it. Correct?
0