Home » RDBMS Server » Networking and Gateways » How do display DBMS_JOB info
How do display DBMS_JOB info [message #367843] Thu, 19 October 2000 14:44 Go to next message
Steven Garcia
Messages: 1
Registered: October 2000
Junior Member
From the PS SQL prompt, how do you display the current jobs that are registered? I need to modify one of our Oracle daily procedures, and I need to know which one it is. I'm not sure how do to this. Any help?

Report message to a moderator

Re: How do display DBMS_JOB info [message #367850 is a reply to message #367843] Wed, 01 November 2000 11:26 Go to previous messageGo to next message
Joe Burke
Messages: 1
Registered: November 2000
Junior Member
Use the DBA_JOBS view.

Report message to a moderator

Re: How do display DBMS_JOB info [message #367880 is a reply to message #367843] Tue, 21 November 2000 09:17 Go to previous message
Marko Ferisak
Messages: 1
Registered: November 2000
Junior Member
select * from dba_jobs;
select * from user_jobs;
select * from dba_jobs_running;

Report message to a moderator

Previous Topic: ORA-12154: TNS:could not resolve service name
Next Topic: ORA-03113
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 23:55:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.