OraFAQ Forum: Client Tools » HOW TO MONITOR JOBS IN TOAD

Home » Other » Client Tools » HOW TO MONITOR JOBS IN TOAD

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW TO MONITOR JOBS IN TOAD [message #397303]

Fri, 10 April 2009 00:11

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

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397304 is a reply to message #397303]

Fri, 10 April 2009 00:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Use SQL to see what you desire

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397306 is a reply to message #397304]

Fri, 10 April 2009 00:16

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

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397307 is a reply to message #397306]

Fri, 10 April 2009 00:19

ramoradba
Messages: 2457
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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397309 is a reply to message #397307]

Fri, 10 April 2009 00:23

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

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397311 is a reply to message #397309]

Fri, 10 April 2009 00:34

trivendra
Messages: 211
Registered: October 2007
Location: Phoenix

Senior Member

From a previous post

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

Thanks
Trivendra

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397316 is a reply to message #397311]

Fri, 10 April 2009 01:02

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

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397317 is a reply to message #397308]

Fri, 10 April 2009 01:07

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.

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397319 is a reply to message #397303]

Fri, 10 April 2009 01:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Congratulations!

You got what you wanted!

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397321 is a reply to message #397317]

Fri, 10 April 2009 01:23

ramoradba
Messages: 2457
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

Report message to a moderator

Re: HOW TO MONITOR JOBS IN TOAD [message #397329 is a reply to message #397316]

Fri, 10 April 2009 01:53

trivendra
Messages: 211
Registered: October 2007
Location: Phoenix

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

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!!!

Report message to a moderator

Previous Topic:	Sql Developer connection with SqL server URGENT
Next Topic:	SQL plus with access MDB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 23 19:48:52 CDT 2025