Results 1 to 10 of 10

Thread: dbms_ijob.run

  1. #1
    Join Date
    Nov 2003
    Posts
    30

    Unanswered: dbms_ijob.run

    Hi all,

    The dba wants to run the job created by another user explicitly during system start ups. I read in the documents that the SYSADM can use DBMS_IJOB directly to control the jobs.

    But the syntax SYS.DBMS_IJOB.run(job_no,true) is not working.
    Please send me the syntax if any of you have used the IJOB package.

    Thanks
    Santhi

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Why do folks insist on paraphrasing what they do & what the system does;
    instead of simply doing a "cut & paste" and actually SHOW exactly what is happening?
    I am not a mind reader & refuse to waste my time guessing.
    You're On Your Own (YOYO)!

    The solution depends directly upon exactly what you are doing
    and exactly how/what Oracle responds.

    AFAIK, there is no such animal as "SYS.DBMS_IJOB.run";
    while I have used DBMS_JOB.RUN on more than one occasion.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2004
    Location
    alabama
    Posts
    5
    O'Reilly's ORACLE BUILT-IN PACKAGES book has a couple of pages devoted to the IJOB package... The book says the package is built by the prvtjob.plb script ... have you tried running that script in your database?

  4. #4
    Join Date
    Nov 2003
    Posts
    30

    Hi

    Thanks for the reply.
    No, I am not aware of this script. Can you send me more details on this please, if you have.

    Thanks
    Santhi

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    show us your EXACT code & the EXACT responses from SQL*Plus.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    May 2004
    Location
    alabama
    Posts
    5
    Script should be located in RDBMS/ADMIN sub-directory of Oracle HOME directory. (but try re-executing your command, without the 'true' parameter ... like this:

    exec sys.dbms_ijob.run(<<job number>>);

  7. #7
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    If such a package exists, it is completely undocumented by Oracle - except for a reference in one error message:
    ORA-12011: execution of string jobs failed
    Cause: An error was caught in dbms_ijob.run from one or more jobs which were due to be run.
    Action: Look at the alert log for details on which jobs failed and why.

  8. #8
    Join Date
    Nov 2003
    Posts
    30

    Link to DBMS_IJOB docs

    http://www.hk8.org/old_web/oracle/bipack/ch13_03.htm

    But this doesn't talk about RUN method.
    Last edited by santhip; 07-09-04 at 11:23.

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    DBMS_IJOB does exist, but only sparely documented


    SYS: DBW.WORLD>desc dbms_ijob
    FUNCTION BIS RETURNS NUMBER
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    FLAG NUMBER IN
    VAL NUMBER IN
    VAL2 BOOLEAN IN
    FUNCTION BIT RETURNS BOOLEAN
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    FLAG NUMBER IN
    VAL NUMBER IN
    PROCEDURE BROKEN
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    BROKEN BOOLEAN IN
    NEXT_DATE DATE IN DEFAULT
    PROCEDURE CHANGE_ENV
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    LUSER VARCHAR2 IN
    PUSER VARCHAR2 IN
    CUSER VARCHAR2 IN
    NLSENV VARCHAR2 IN
    PROCEDURE CHECK_PRIVS
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    FUNCTION DB_COMPATIBILITY RETURNS NUMBER
    PROCEDURE DROP_USER_JOBS
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    MYUSER VARCHAR2 IN
    FUNCTION ENABLED RETURNS BOOLEAN
    PROCEDURE EXPORT_MYINST
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    MYINST VARCHAR2 IN/OUT
    PROCEDURE FULL_EXPORT
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    MYCALL VARCHAR2 IN/OUT
    PROCEDURE FULL_EXPORT
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    MYCALL VARCHAR2 IN/OUT
    MYINST VARCHAR2 IN/OUT
    PROCEDURE INSTANCE
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    INSTANCE BINARY_INTEGER IN
    FORCE BOOLEAN IN
    PROCEDURE INST_CHECK
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    INSTANCE NUMBER IN
    FORCE BOOLEAN IN
    PROCEDURE INTERVAL
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    INTERVAL VARCHAR2 IN
    PROCEDURE NEXT_DATE
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    NEXT_DATE DATE IN
    FUNCTION PUID RETURNS NUMBER
    FUNCTION PUSER RETURNS VARCHAR2
    PROCEDURE REMOVE
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    PROCEDURE RUN
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN DEFAULT
    FORCE BOOLEAN IN DEFAULT
    PROCEDURE SET_ENABLED
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    ENABLED BOOLEAN IN
    PROCEDURE SUBMIT
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    LUSER VARCHAR2 IN
    PUSER VARCHAR2 IN
    CUSER VARCHAR2 IN
    NEXT_DATE DATE IN
    INTERVAL VARCHAR2 IN
    BROKEN BOOLEAN IN
    WHAT VARCHAR2 IN
    NLSENV VARCHAR2 IN
    ENV RAW IN
    PROCEDURE SUBMIT
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    LUSER VARCHAR2 IN
    PUSER VARCHAR2 IN
    CUSER VARCHAR2 IN
    NEXT_DATE DATE IN
    INTERVAL VARCHAR2 IN
    BROKEN BOOLEAN IN
    WHAT VARCHAR2 IN
    CS_LAB RAW MLSLABEL IN
    CL_HI RAW MLSLABEL IN
    CL_LO RAW MLSLABEL IN
    NLSENV VARCHAR2 IN
    ENV RAW IN
    FUNCTION TOGGLE RETURNS NUMBER
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    FLAG NUMBER IN
    VAL NUMBER IN
    PROCEDURE WHAT
    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    JOB BINARY_INTEGER IN
    WHAT VARCHAR2 IN

    SYS: DBW.WORLD>
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

Posting Permissions

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