Scheduler

Log in to follow, share, and participate in this community.
Filter by tag
12PreviousNext
  • Chain configuration

    Hi, all.   Chain Newby here.   I'm hoping someone can help orient me in the chain space.   My problem ultimately is that my chain is stalling out and I'm not quite sure how to see why it stalls. &nbs...
    Fritz-OC
    last modified by Fritz-OC
    Chain configuration

    in Scheduler

      Back
    • hot backup full disk job Scheduled failed

      Hello,   We are facing the issue with hot backup job. Can some one help me on this how to fix.   Here is the error log message..   RMAN-00571: ========================================================...
      hot backup full disk job Scheduled failed

      in Scheduler

        Back
      • Scheduler job not working as expected in 10.2.0.5

        Hi Guys,   I have create a scheduler job which will execute a stored procedure to kill the "SNIPED" database session. However, the scheduler job is not running as per expect. Based on my testing, I have drop a...
        SagiGal
        last modified by SagiGal
        Scheduler job not working as expected in 10.2.0.5

        in Scheduler

          Back
        • How to Schedule Jobs to only run during a time window

          I have a long running task that needs to schedule jobs to process data. I only want these scheduled jobs to start during a specific window of time each day, probably 10:00 PM to 6:00 AM.   If the scheduled jobs...
          jeff.blankenbiller
          last modified by jeff.blankenbiller
          How to Schedule Jobs to only run during a time window

          in Scheduler

            Back
          • Passing CLOB to DBMS_SCHEDULER.SET_JOB_ANYDATA_VALUE

            I'm using OracleXE 11g. My question is: "Is it possible to pass CLOB value to DBMS_SCHEDULER.SET_JOB_ANYDATA_VALUE?" Example: Doesn't work:   begindbms_scheduler.set_job_anydata_value(job_name => 'some_job'...
            MiroMas
            last modified by MiroMas
            Passing CLOB to DBMS_SCHEDULER.SET_JOB_ANYDATA_VALUE

            in Scheduler

              Back
            • DBMS_SCHEDULER and Shell Script on 10.2.0.1

              Hi All   My env, Oracle 10.2.0.1 and OS is Solaris.   My script can run on OS that is work without error that contain create file, delete file, call sqlplus, function to get value from database and return ...
              taohiko
              last modified by taohiko
              DBMS_SCHEDULER and Shell Script on 10.2.0.1

              in Scheduler

                Back
              • WGET and DBMS_SCHEDULER

                Hi All   I create shell script as below ============================================= (w.sh) $FILE_PATH/wget_file.sh $USERNAME $PASSWORD $FILE_PATH $URL1 $FILE_PATH/wget_file.sh $USERNAME $PASSWORD $FILE_PAT...
                taohiko
                last modified by taohiko
                WGET and DBMS_SCHEDULER

                in Scheduler

                  Back
                • DBMS scheduler - restricting one job run

                  Hi All, I have a specific question on Oracle DBMS_SCHEDULER and need guidance from the forum. Database version is 10.2.0.4   I scheduled a job which is supposed to run every day at 11pm. This scheduler calls a...
                  user8211187
                  last modified by user8211187
                  DBMS scheduler - restricting one job run

                  in Scheduler

                    Back
                  • Schedular Job Email Notification

                    I have used the directions from the following link to set up email notifications.  When I execute the job I don't receive any email?  I have setup the email in OEM under Setup => Notification Methods and ...
                    CycleGeek
                    last modified by CycleGeek
                    Schedular Job Email Notification

                    in Scheduler

                      Back
                    • A scheduler job getting hung causing critical issues

                      Hi Experts,   We are on Oracle 11.2.0.2 on Linux. We have some jobs that are scheduled to run at night time like 1 am etc. These jobs copy data from some of the main OLTP tables in the archive tables that are in...
                      orausern
                      last modified by orausern
                      A scheduler job getting hung causing critical issues

                      in Scheduler

                        Back
                      • Scheduler for analyzing tables and other tasks

                        Hi,   DB: 11gR2 on Windows Server 2008R2   1. Is there an example of how to enable (set up) the Scheduler for maintenance jobs, i.e. analyzing tables and checking these tasks/settings:   /* Checkin...
                        user545194
                        last modified by user545194
                        Scheduler for analyzing tables and other tasks

                        in Scheduler

                          Back
                        • Question on scheduler

                          Hi Experts,   I have a question on a scheduling jobs.   which one will take high priority while running the jobs through either DBMS_SCHEDULER with priority 3 or DBMS_JOB?   and is there any way to f...
                          995371
                          last modified by 995371
                          Question on scheduler

                          in Scheduler

                            Back
                          • get_attribute procedure

                            Hi All,       In my application I have already used dbms_scheduler.set_attribute procedure. Now am trying to implement get_attribute procedure. But am facing a lot of issues in it.   M...
                            Kanishkaa
                            last modified by Kanishkaa
                            get_attribute procedure

                            in Scheduler

                              Back
                            • Add Email Job Notification via SQL Developer

                              Hello,   I'm a novice in the Oracle Scheduler space and I have what is likely a novice question.  However, I'm thoroughly turned around after searching and would gladly welcome some help.   I'm using ...
                              Fritz-OC
                              last modified by Fritz-OC
                              Add Email Job Notification via SQL Developer

                              in Scheduler

                                Back
                              • Scheduled Chained Steps

                                I've been trying to create a Scheduler Chain in Oracle 11.2 to kick off steps based off of a schedule.  Below is an example script I used to attempt this, what I would like is Step1 to execute with the start of t...
                                RobbR
                                last modified by RobbR
                                Scheduled Chained Steps

                                in Scheduler

                                  Back
                                • How to create scheduler sql oracle developer

                                  Hi   how to create How to create scheduler sql oracle developer?
                                  ASulthan
                                  last modified by ASulthan
                                  How to create scheduler sql oracle developer

                                  in Scheduler

                                    Back
                                  • dbms_scheduler jobs scheduling for Day light Savings

                                    Version: 11.2.0.2.0   Hello Guys, got a bit of a problem on which I am stuck.   There are couple of jobs that are scheduled through DBMS_SCHEDULER to run on 11:20 AM today   select start_date from db...
                                    968751
                                    last modified by 968751
                                    dbms_scheduler jobs scheduling for Day light Savings

                                    in Scheduler

                                      Back
                                    • Is it possible to rename a dmbs schedule?

                                      DBMS_SCHEDULER: Just like the question about renaming jobs:Rename a scheduled job But there is no option to copy schedules, so is there a way?
                                      miersuzzemes
                                      last modified by miersuzzemes
                                      Is it possible to rename a dmbs schedule?

                                      in Scheduler

                                        Back
                                      • FILE WATCHER - JOB IS NOT RUNNING

                                        Hi All. I have below problem with dbms_scheduler,  file watcher job. I am creating file watcher like this : BEGIN   dbms_scheduler.create_credential(credential_name => 'cred_file_watcher',  &...
                                        Ramin Hashimzadeh
                                        last modified by Ramin Hashimzadeh
                                        FILE WATCHER - JOB IS NOT RUNNING

                                        in Scheduler

                                          Back
                                        • pl/sql

                                          I am using apex 4.0.2 version,Actually i want to take export of my database by using this procedure.... when i tried yhis procedure on windows machine,its working fine.. but in ubuntu machine the database is not get...
                                          Abhishek12991
                                          last modified by Abhishek12991
                                          pl/sql

                                          in Scheduler

                                            Back
                                          12PreviousNext

                                          Actions