Home » RDBMS Server » Server Administration » DBMS_JOB using sys account (oracle 10g R2, linus 5)
DBMS_JOB using sys account [message #461335] Thu, 17 June 2010 08:01 Go to next message
sahadba
Messages: 54
Registered: September 2009
Location: Pune
Member

Hi,

I have to change the execution of a job, I have the sys access.
The job is in another user, say scott.
Please let me how to use dbms_change using sys account to change the execution of a job in Scott user..

Thank You
Re: DBMS_JOB using sys account [message #461344 is a reply to message #461335] Thu, 17 June 2010 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have no dbms_change in my database.
Post:
select owner, object_type from dba_objects where object_name = 'DBMS_CHANGE';
select banner from v$version where banner like '%Database%';

Regards
Michel
Re: DBMS_JOB using sys account [message #461349 is a reply to message #461344] Thu, 17 June 2010 08:30 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
Do you maybe mean DBMS_JOB.CHANGE?
Re: DBMS_JOB using sys account [message #461352 is a reply to message #461349] Thu, 17 June 2010 08:34 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case, I think you have to use DBMS_IJOB but it is neither documented nor supported.
It should be better you connect as scott itself and use DBMS_JOB.

Regards
Michel
Re: DBMS_JOB using sys account [message #461359 is a reply to message #461344] Thu, 17 June 2010 09:07 Go to previous messageGo to next message
sahadba
Messages: 54
Registered: September 2009
Location: Pune
Member

I am sorry for the typo mistake.

I meant
dbms_job.change

Please let me how to execute a job in scott using sys authorization
Re: DBMS_JOB using sys account [message #461366 is a reply to message #461359] Thu, 17 June 2010 09:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read my previous answer.

Regards
Michel
Re: DBMS_JOB using sys account [message #515740 is a reply to message #461366] Wed, 13 July 2011 02:59 Go to previous messageGo to next message
jhenno22
Messages: 10
Registered: June 2011
Location: Philippines
Junior Member
hi! I have a similar question, but the command is DBMS_JOB.SUBMIT
I'm logged in as APPLE and I want to create a job in ORANGE schema. BUT I also have MANGO and BANANA as another schemas.
Using DBMS_IJOB, how will I make sure that the job I created will be in ORANGE schema?
Thanks!
Re: DBMS_JOB using sys account [message #515747 is a reply to message #515740] Wed, 13 July 2011 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query DBA_JOBS.

Regards
Michel
Re: DBMS_JOB using sys account [message #515788 is a reply to message #515747] Wed, 13 July 2011 04:26 Go to previous messageGo to next message
jhenno22
Messages: 10
Registered: June 2011
Location: Philippines
Junior Member
I guess what you are saying is after I run the DBMS_IJOB.SUBMIT, I'll query the DBA_JOBS to see where it is created...

But what I'm asking is how will I point the DBMS_IJOB.SUBMIT to create the job in ORANGE schema?
Re: DBMS_JOB using sys account [message #515846 is a reply to message #515788] Wed, 13 July 2011 09:35 Go to previous message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a not documented and internal package, so make your test
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

See the %USER parameters and compare them with the DBA_JOBS column definition; conclusion?

Regards
Michel
Previous Topic: creating database(4 Merged)
Next Topic: difference between V_$ and V$ views
Goto Forum:
  


Current Time: Wed Sep 17 15:10:44 CDT 2014

Total time taken to generate the page: 0.13243 seconds