The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

How to write stdout or stderr to a particular file when using oracle dbms_scheduler to run external job?

I create a job like BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'job_testing', job_type => 'EXECUTABLE', job_action => ...
0
votes
0answers
27 views

Trying to run a shell script from dbms_scheduler . Throws error no matter what the script is?

I am trying to run a shell script from a dbms_scheduler but am getting a bunch of errors :- the job defn :- BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_prog', ...
1
vote
1answer
48 views

Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?

A database application I'm working with uses Oracle scheduled jobs to perform certain tasks. The DBA insists that hard-coding the schema name in the procedures that organise these jobs improves ...
0
votes
1answer
83 views

Oracle DBMS Scheduler - what if database fails?

We are moving some Oracle overnight jobs off a cron server and running them via Oracle DBMS Scheduler instead. It is my understanding that if the database fails overnight then the job email ...
1
vote
1answer
48 views

Dropping a schedule whose name contain '.'

I was attempting to create a schedule called MYSCHEMA.MYSCHED in my Oracle database using SQL Developer 4.0 Early Access, and there appears to be a bug resulting in a schedule named MYSCHEMA. to be ...
2
votes
2answers
822 views

DBMS_SCHEDULER event schedule jobs not executed when triggered almost at the same time

I moved this question from stackoverflow to here as it was marked on hold as off-topic. On Oracle 10g2 DB I have set up multiple event triggered DMBS_SCHEDULER jobs and all of them are subscribed for ...
2
votes
1answer
360 views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
0
votes
0answers
164 views

DBA_SCHEDULER_Job is not giving any result

I have created one procedure that is supposed to trigger on 5th date of every month.for that i have used dba scheduler job.but its not triggering. select job_name,status from dba_scheduler_jobs; ...
2
votes
1answer
867 views

Specify Server for DBMS_Scheduler Job in Policy Managed RAC

A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
3
votes
2answers
561 views

Disabling DBMS_SCHEDULER queue

Despite a lot of searching, I can't seem to find a solution to this problem we are having. Our system enables users to submit certain processes to be run in background while they continue working. ...
2
votes
0answers
361 views

Isssue with Database Links converting OEM Job to DBMS_Scheduler Job

We had an OEM job that would run a PL/SQL block using a particular database users credentials. The credentials are the same for two different databases, so there was no problem for the block to use a ...