Results 1 to 4 of 4

Thread: Jobs

  1. #1
    Join Date
    Sep 2003
    Posts
    51

    Unanswered: Jobs

    Hi all,

    a question : How can I see all the jobs in a instance ? How can I submit jobs ?

    The problem : I need to know everything about jobs, where can I read about ?

    thanks,

    Antonio Freitas

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Look in the distributed transaction portion (or replication) of the documentation ... also look at the doc for dbms_job ...
    (dbms_job.submit ... to load jobs and give a schedule
    dbms_job.run ... to run jobs now ... etc ...

    Jobs are located in dba_jobs ....

    sql> select owner,job, what from dba_jobs;

    hth
    Gregg

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up Re: Jobs

    Hi ajfreitas,

    The DBMS_JOB package helps you to develop batch processes that run within the Oracle database. The job run must be a PL/SQL stored procedure. To set up the job in the job queue, you run the submit( ) procedure, while to get it out of the job queue, you can run remove( ). Jobs have a description, an interval or frequency of execution, and the next date defined for which they will run. These items can be changed individually with what( ), interval( ), and next_date( ), respectively. The more generalized change( ) procedure can be used to change any of these things as well. Jobs that fail upon execution are marked "broken" by Oracle, and will not run again until they are fixed. Alternately, you can stop a job from being run by breaking it manually with broken( ). Once the job is fixed, you force job execution with run( ). If the job runs successfully, Oracle marks the job as not broken anymore.
    thanks,
    SATHISH .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •