OraFAQ Forum: Server Administration » DBMS

Home » RDBMS Server » Server Administration » DBMS_JOB using sys account (oracle 10g R2, linus 5)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

DBMS_JOB using sys account [message #461335]

Thu, 17 June 2010 08:01

sahadba
Messages: 43
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

Report message to a moderator

Re: DBMS_JOB using sys account [message #461344 is a reply to message #461335]

Thu, 17 June 2010 08:24

Michel Cadot
Messages: 54718
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

Report message to a moderator

Re: DBMS_JOB using sys account [message #461349 is a reply to message #461344]

Thu, 17 June 2010 08:30

Frank Naude
Messages: 4381
Registered: April 1998

Senior Member

Do you maybe mean DBMS_JOB.CHANGE?

Report message to a moderator

Re: DBMS_JOB using sys account [message #461352 is a reply to message #461349]

Thu, 17 June 2010 08:34

Michel Cadot
Messages: 54718
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

Report message to a moderator

Re: DBMS_JOB using sys account [message #461359 is a reply to message #461344]

Thu, 17 June 2010 09:07

sahadba
Messages: 43
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

Report message to a moderator

Re: DBMS_JOB using sys account [message #461366 is a reply to message #461359]

Thu, 17 June 2010 09:56

Michel Cadot
Messages: 54718
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Read my previous answer.

Regards
Michel

Report message to a moderator

Re: DBMS_JOB using sys account [message #515740 is a reply to message #461366]

Wed, 13 July 2011 02:59

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!

Report message to a moderator

Re: DBMS_JOB using sys account [message #515747 is a reply to message #515740]

Wed, 13 July 2011 03:10

Michel Cadot
Messages: 54718
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Query DBA_JOBS.

Regards
Michel

Report message to a moderator

Re: DBMS_JOB using sys account [message #515788 is a reply to message #515747]

Wed, 13 July 2011 04:26

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?

Report message to a moderator

Re: DBMS_JOB using sys account [message #515846 is a reply to message #515788]

Wed, 13 July 2011 09:35

Michel Cadot
Messages: 54718
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 00:51:34 CDT 2013

Total time taken to generate the page: 0.11352 seconds