Home » SQL & PL/SQL » Client Tools » HOW TO MONITOR JOBS IN TOAD
HOW TO MONITOR JOBS IN TOAD [message #397303] Fri, 10 April 2009 00:11 Go to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
Hi,

can somebody plz.let me know how can i monitor my jobs that run everyday in toad.

thanks and regards
siva
Re: HOW TO MONITOR JOBS IN TOAD [message #397304 is a reply to message #397303] Fri, 10 April 2009 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Use SQL to see what you desire
Re: HOW TO MONITOR JOBS IN TOAD [message #397306 is a reply to message #397304] Fri, 10 April 2009 00:16 Go to previous messageGo to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
did not understand your reply... request you to kindly xplain me in detail.

thanks and regards
siva
Re: HOW TO MONITOR JOBS IN TOAD [message #397307 is a reply to message #397306] Fri, 10 April 2009 00:19 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
how can i monitor my jobs that run everyday in toad


What exactly you Mean? jobs submited by you? or what ever the transactions(queries) you performed?

Please let me know

Thanks & regards
Sriram

[Updated on: Fri, 10 April 2009 00:19]

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397308 is a reply to message #397303] Fri, 10 April 2009 00:20 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>let me know how can i monitor my jobs that run everyday in toad
How do you identify the jobs?
How do you analyze the results?

Formulate your queries & take action based upon results.
Re: HOW TO MONITOR JOBS IN TOAD [message #397309 is a reply to message #397307] Fri, 10 April 2009 00:23 Go to previous messageGo to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
ramoradba wrote on Fri, 10 April 2009 00:19
Quote:
how can i monitor my jobs that run everyday in toad


What exactly you Mean? jobs submited by you? or what ever the transactions(queries) you performed?

Please let me know

Thanks & regards
Sriram




Dear Sriram,

I have a procedure which i run it at 6:00am everyday as a job. but frm past couple of days its not finishing i mean its taking too much of time to complete. I would like to knw how can i monitor this job to knw if there is any problem with its execution or atleast knw the %ge of job completed.

thanks and regards
siva
Re: HOW TO MONITOR JOBS IN TOAD [message #397311 is a reply to message #397309] Fri, 10 April 2009 00:34 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
From a previous post

http://www.orafaq.com/forum/t/143391/113651/

Thanks
Trivendra
Re: HOW TO MONITOR JOBS IN TOAD [message #397316 is a reply to message #397311] Fri, 10 April 2009 01:02 Go to previous messageGo to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
trivendra wrote on Fri, 10 April 2009 00:34
From a previous post

http://www.orafaq.com/forum/t/143391/113651/

Thanks
Trivendra



the query in the link shows %age of index rebuild and not the %age of stored procedure completed.

thanks and regards
siva
Re: HOW TO MONITOR JOBS IN TOAD [message #397317 is a reply to message #397308] Fri, 10 April 2009 01:07 Go to previous messageGo to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
BlackSwan wrote on Fri, 10 April 2009 00:20
>let me know how can i monitor my jobs that run everyday in toad
How do you identify the jobs?
How do you analyze the results?

Formulate your queries & take action based upon results.



analyze the result.
Re: HOW TO MONITOR JOBS IN TOAD [message #397319 is a reply to message #397303] Fri, 10 April 2009 01:14 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Congratulations!


You got what you wanted!
Re: HOW TO MONITOR JOBS IN TOAD [message #397321 is a reply to message #397317] Fri, 10 April 2009 01:23 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Read the document

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schedadmin.htm#i1007589

Thanks & regards
Sriram
Re: HOW TO MONITOR JOBS IN TOAD [message #397329 is a reply to message #397316] Fri, 10 April 2009 01:53 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
siva.n.subramanian wrote on Fri, 10 April 2009 11:32
trivendra wrote on Fri, 10 April 2009 00:34
From a previous post

http://www.orafaq.com/forum/t/143391/113651/

Thanks
Trivendra



the query in the link shows %age of index rebuild and not the %age of stored procedure completed.

thanks and regards
siva



Really sorry to see your efforts.

You must have tried to look at the link given.

http://www.dba-oracle.com/longops.htm

and

DBMS_APPLICATION_INFO


Thanks
Trivendra

[Updated on: Fri, 10 April 2009 01:53]

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397336 is a reply to message #397321] Fri, 10 April 2009 02:12 Go to previous message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
ramoradba wrote on Fri, 10 April 2009 01:23
Read the document

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schedadmin.htm#i1007589

Thanks & regards
Sriram



thanks a ton!!!
Previous Topic: Sql Developer connection with SqL server URGENT
Next Topic: SQL plus with access MDB
Goto Forum:
  


Current Time: Sat Dec 03 03:40:42 CST 2016

Total time taken to generate the page: 0.07154 seconds