Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Tag Archives: dbms_scheduler
Jobs failing to run.
ORA-27370: job slave failed to launch a job of type EXECUTABLE Trying to schedule a backup on a database in windows using the job scheduler, each time the job to run the executable failed with the above error. But the … Continue reading
Posted in Configuration.
Tagged backup, dbms_scheduler, JOB_NAMEl, ORA-27300, ORA-27301, ORA-27302, ORA-27303, ORA-27370
Comments Off
Insufficient privileges purging scheduler logs.
Cannot purge the job history logs ? If you get insufficient privileges, you require the SCHEDULER_ADMIN role.
Posted in Oracle
Tagged CLASSES, CREATE~ANY~JOB;, CREATE~JOB, dbms_scheduler, JOB, programs, windows
Comments Off
ORA-02800: Requests timed out
I had a simple job to run, which failed. exec dbms_scheduler.run_job(‘CHECKJOB’); returned the following. ERROR at line 1:ORA-02800: Requests timed outORA-06512: at “SYS.DBMS_ISCHED”, line 150ORA-06512: at “SYS.DBMS_SCHEDULER”, line 441ORA-06512: at line 2
Posted in Oracle
Tagged 473551, 473551.1, dbms_scheduler, dbms_scheduler.run_job, Metalink, ORA-02800, RUN_JOB
Comments Off
Database Backup from Scheduler.
I wanted to backup a database using an OS script, but scheduled from the database rather than from the OS. Here’s the setup for it.
Changing event_spec on scheduler jobs.
Had an interesting problem, a sequence of materialized views scheduled from event driven jobs were not running. Turns out that the job event was on JOB_SUCCEEDED rather than JOB_COMPLETED. It would take a long time to update the spec on … Continue reading
Scheduler Event Based Jobs.
I trawled through the documentation and articles on the web for one which would show an event based job, on the sys users scheduler queue table, rather than my own. Since it took so long to get it all working, … Continue reading
Refreshing a materialized view at different times.
A client required a number of materialized views to be refreshed at various times, which did not have a regular pattern. From this, we could create a complex scheduler for the refresh group, or we could create a set of … Continue reading
Posted in Configuration., Oracle
Tagged dbms_mview, dbms_refresh, dbms_scheduler, frequency
Comments Off
