Home » SQL & PL/SQL » SQL & PL/SQL » job scheduling
job scheduling [message #321447] Tue, 20 May 2008 05:21 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
i want to write a a procedure that returns me all the processes and jobs that are being run on my database at present and also their time stamp like start date end date/time , current status.
please any oone tell me how can i achieve this.
on forms or at database level.

[Updated on: Tue, 20 May 2008 05:21]

Report message to a moderator

Re: job scheduling [message #321460 is a reply to message #321447] Tue, 20 May 2008 05:53 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Quote:
on forms or at database level

on forms means what?

You will get all active/inactive sessions from v$session.
If application is running, then if it is not accessing Database, it will show session as Inactive till the database is accessed once again and so on.

Regards,

MSMallya

[Updated on: Tue, 20 May 2008 05:59]

Report message to a moderator

Re: job scheduling [message #321463 is a reply to message #321447] Tue, 20 May 2008 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you are talking about "jobs" in Oracle meaning, have a look at DBA_JOBS_RUNNING or DBA_SCHEDULER_RUNNING_JOBS.

Regards
Michel
Re: job scheduling [message #321467 is a reply to message #321463] Tue, 20 May 2008 06:17 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member

i want to create an interface from which i can view all the processes that are run by my clients and also the processes which started and ended during the day ,
and the timestamps of all the processes ( start time and end time) .
thanx again in advance,
Re: job scheduling [message #321468 is a reply to message #321467] Tue, 20 May 2008 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version (4 decimals)?

Regards
Michel
Re: job scheduling [message #322395 is a reply to message #321468] Fri, 23 May 2008 06:21 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
I am Not Clear yet ,
so kindly pals do suggest me .
Re: job scheduling [message #322397 is a reply to message #322395] Fri, 23 May 2008 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 20 May 2008 13:19
Oracle version (4 decimals)?

Regards
Michel


so kindly guy do answer me
Re: job scheduling [message #322405 is a reply to message #322397] Fri, 23 May 2008 06:44 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
Sir ,
I feel Sorry to Tell you ,
I did not understand what u mean by
Oracle version (4 decimals)?

Regards
Michel

I know its my Lack of Knowledge , but i hope u explain it.

Thanks.
Re: job scheduling [message #322409 is a reply to message #322405] Fri, 23 May 2008 06:55 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

Sispk6

He wants version number of oracle DB.For example 9.2.0.7.0.
Login to yours sql using Sql*Plus and it will appear there when you logged on.

Thanks
Mandep
Re: job scheduling [message #322411 is a reply to message #322405] Fri, 23 May 2008 06:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you use Oracle.
Oracle products have a version.
This is on 5 decimals like 10.2.0.4.0

I asked you for this.

Regards
Michel
Re: job scheduling [message #322414 is a reply to message #322411] Fri, 23 May 2008 07:46 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Re: job scheduling [message #323280 is a reply to message #322414] Wed, 28 May 2008 01:14 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
kindly Help Sad
Re: job scheduling [message #323282 is a reply to message #321447] Wed, 28 May 2008 01:16 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
OK
Previous Topic: natural join
Next Topic: OAS - Web page issue
Goto Forum:
  


Current Time: Sun Dec 11 02:31:15 CST 2016

Total time taken to generate the page: 0.10591 seconds