Home » RDBMS Server » Server Administration » Find dbms_scheduler Jobs Running (Oracle 10.2.0.3.0 Windows 2003)
Find dbms_scheduler Jobs Running [message #429783] Thu, 05 November 2009 15:06 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
Hi,

I have created a job using dbms_scheduler. Whether any view available to find which job is running right now as we have dba_jobs_running to find the jobs running created using dbms_job.

[Updated on: Thu, 05 November 2009 15:10]

Report message to a moderator

Re: Find dbms_scheduler Jobs Running [message #429812 is a reply to message #429783] Thu, 05 November 2009 19:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> desc dba_scheduler_jobs
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER					   NOT NULL VARCHAR2(30)
 JOB_NAME				   NOT NULL VARCHAR2(30)
 JOB_SUBNAME					    VARCHAR2(30)
 JOB_CREATOR					    VARCHAR2(30)
 CLIENT_ID					    VARCHAR2(64)
 GLOBAL_UID					    VARCHAR2(32)
 PROGRAM_OWNER					    VARCHAR2(4000)
 PROGRAM_NAME					    VARCHAR2(4000)
 JOB_TYPE					    VARCHAR2(16)
 JOB_ACTION					    VARCHAR2(4000)
 NUMBER_OF_ARGUMENTS				    NUMBER
 SCHEDULE_OWNER 				    VARCHAR2(4000)
 SCHEDULE_NAME					    VARCHAR2(4000)
 SCHEDULE_TYPE					    VARCHAR2(12)
 START_DATE					    TIMESTAMP(6) WITH TIME ZONE
 REPEAT_INTERVAL				    VARCHAR2(4000)
 EVENT_QUEUE_OWNER				    VARCHAR2(30)
 EVENT_QUEUE_NAME				    VARCHAR2(30)
 EVENT_QUEUE_AGENT				    VARCHAR2(30)
 EVENT_CONDITION				    VARCHAR2(4000)
 EVENT_RULE					    VARCHAR2(65)
 END_DATE					    TIMESTAMP(6) WITH TIME ZONE
 JOB_CLASS					    VARCHAR2(30)
 ENABLED					    VARCHAR2(5)
 AUTO_DROP					    VARCHAR2(5)
 RESTARTABLE					    VARCHAR2(5)
 STATE						    VARCHAR2(15)
 JOB_PRIORITY					    NUMBER
 RUN_COUNT					    NUMBER
 MAX_RUNS					    NUMBER
 FAILURE_COUNT					    NUMBER
 MAX_FAILURES					    NUMBER
 RETRY_COUNT					    NUMBER
 LAST_START_DATE				    TIMESTAMP(6) WITH TIME ZONE
 LAST_RUN_DURATION				    INTERVAL DAY(9) TO SECOND(6)
 NEXT_RUN_DATE					    TIMESTAMP(6) WITH TIME ZONE
 SCHEDULE_LIMIT 				    INTERVAL DAY(3) TO SECOND(0)
 MAX_RUN_DURATION				    INTERVAL DAY(3) TO SECOND(0)
 LOGGING_LEVEL					    VARCHAR2(4)
 STOP_ON_WINDOW_CLOSE				    VARCHAR2(5)
 INSTANCE_STICKINESS				    VARCHAR2(5)
 RAISE_EVENTS					    VARCHAR2(4000)
 SYSTEM 					    VARCHAR2(5)
 JOB_WEIGHT					    NUMBER
 NLS_ENV					    VARCHAR2(4000)
 SOURCE 					    VARCHAR2(128)
 DESTINATION					    VARCHAR2(128)
 COMMENTS					    VARCHAR2(240)
 FLAGS						    NUMBER
Re: Find dbms_scheduler Jobs Running [message #429874 is a reply to message #429783] Fri, 06 November 2009 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBA_SCHEDULER_RUNNING_CHAINS
DBA_SCHEDULER_RUNNING_JOBS
V$SCHEDULER_RUNNING_JOBS

Regards
Michel
Re: Find dbms_scheduler Jobs Running [message #433077 is a reply to message #429783] Sun, 29 November 2009 15:11 Go to previous message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Thanks Michel..
Previous Topic: Compilers for oracle patching
Next Topic: Characterset Change
Goto Forum:
  


Current Time: Fri Nov 29 11:27:23 CST 2024