Home » SQL & PL/SQL » SQL & PL/SQL » find out which job is calling particular package
find out which job is calling particular package [message #240627] Fri, 25 May 2007 06:30 Go to next message
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
Junior Member
REspected sir,

Please tell me How to find out which job is calling particular package.

Even i was tried out with dbms_job data dictionary , i am not getting the result.

Regards,
user
Re: find out which job is calling particular package [message #240631 is a reply to message #240627] Fri, 25 May 2007 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> desc dba_jobs
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 JOB                              NOT NULL NUMBER
 LOG_USER                         NOT NULL VARCHAR2(30)
 PRIV_USER                        NOT NULL VARCHAR2(30)
 SCHEMA_USER                      NOT NULL VARCHAR2(30)
 LAST_DATE                                 DATE
 LAST_SEC                                  VARCHAR2(8 CHAR)
 THIS_DATE                                 DATE
 THIS_SEC                                  VARCHAR2(8 CHAR)
 NEXT_DATE                        NOT NULL DATE
 NEXT_SEC                                  VARCHAR2(8 CHAR)
 TOTAL_TIME                                NUMBER
 BROKEN                                    VARCHAR2(1 CHAR)
 INTERVAL                         NOT NULL VARCHAR2(200)
 FAILURES                                  NUMBER
 WHAT                                      VARCHAR2(4000)
 NLS_ENV                                   VARCHAR2(4000)
 MISC_ENV                                  RAW(32)
 INSTANCE                                  NUMBER

WHAT gives you what the job executes.

Regards
Michel
Re: find out which job is calling particular package [message #240639 is a reply to message #240631] Fri, 25 May 2007 06:46 Go to previous messageGo to next message
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
Junior Member
Respected Sir,

Even i was tried that , But my requirement i need to know which job is calling my package or which job is refreshing my package.

How to find this job number.

PLease help me regarding this.

Sincerely,
Re: find out which job is calling particular package [message #240644 is a reply to message #240639] Fri, 25 May 2007 07:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You could look at DBA_JOBS_RUNNING
Re: find out which job is calling particular package [message #240647 is a reply to message #240644] Fri, 25 May 2007 07:19 Go to previous messageGo to next message
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
Junior Member
Respected Sir,

Yes i got solution for that even i solved that task too.

Thank's a lot for your good answer Sir.

Thanking you.
Re: find out which job is calling particular package [message #240651 is a reply to message #240647] Fri, 25 May 2007 07:27 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Sir JRowbottom
A true Knight of the British Empire Grin
Re: find out which job is calling particular package [message #240728 is a reply to message #240651] Fri, 25 May 2007 10:25 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The knights that say 'NVL'
Previous Topic: Analyze table
Next Topic: about database review
Goto Forum:
  


Current Time: Sun Dec 11 02:05:35 CST 2016

Total time taken to generate the page: 0.05600 seconds