All Questions
Tagged with scheduled-tasks oracle
9 questions
0
votes
2
answers
4k
views
Run query every 5 minutes
Please find the below query:
select count(*) from v$session;
This has to be run on the database every 5 minutes. What is the right way to achieve this?
The query has to be run every 5 minutes on the ...
-1
votes
2
answers
1k
views
Why would a scheduled job fail in SQL Developer?
I am trying to create a scheduled job in Oracle SQL Developer that would run once a month and I am testing the Scheduler/Jobs feature where I have created a simple SQL query to test the ability to do ...
- 111
0
votes
1
answer
127
views
Oracle 11g - Database Job About User Lock
I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure.
The procedure must comply with the rules I have specified below:
If a user's expiry_date value ...
- 55
0
votes
3
answers
4k
views
Oracle 12c and Jobs running one hour apart after changing time for hourly use
I have an Oracle 12c database in which I have detected that the scheduled jobs are running one hour apart after the change of time on the server, checking in the database I see that the SYSTIMESTAMP ...
- 169
1
vote
1
answer
834
views
executing a stored procedure on a monthly schedule
I'm looking to create an invoicing procedure that executes automatically once a month. The procedure name is INVOICE_PROC.
I have tried to use a trigger to execute it but I can't get it to work. ...
- 11
1
vote
2
answers
2k
views
Run shell script on Oracle 11g
I have an oracle database:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for Linux: Version 11.2.0.1.0 - ...
- 113
1
vote
2
answers
4k
views
Stop long running scheduled job
I need to launch a scheduled job at 12 o'clock at night and keep this job running for a period of 8 hours. What happens now is that the job is running for more than 12 hours and I really need to avoid ...
- 145
1
vote
1
answer
311
views
Create a job from dbms_scheduler with stream redirection?
I want to create a simple job who have to execute this shell command:
echo some_text > some_file
The attributes some_text and some_file can change between two calls to run_job so I need to use ...
- 177
3
votes
3
answers
7k
views
Ways to Schedule Rman backups
I am using oracle 11g database in windows platform. Also, my db is in archivelog mode and I am taking daily RMAN backups. Now, I need to schedule my Rman backups on daily and weekly basis. I read ...
- 152