Home » RDBMS Server » Server Administration » Job Run Time (10.2.0.4.0, IBM AIX)
Job Run Time [message #461639] Sun, 20 June 2010 04:01 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi,

Is there any way to find the last run duration of a job which was scheduled using DBMS_JOB?

Report message to a moderator

Re: Job Run Time [message #461646 is a reply to message #461639] Sun, 20 June 2010 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.

Regards
Michel

Report message to a moderator

Re: Job Run Time [message #461671 is a reply to message #461639] Sun, 20 June 2010 18:54 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
Hi Michel,

thanks for the information.

Actually,

TOTAL_TIME
Total wallclock time spent by the system on this job,in seconds

Is this column provides information about the job run duration.

Can we see the job run execution duration time in EM.

Report message to a moderator

Re: Job Run Time [message #461672 is a reply to message #461671] Sun, 20 June 2010 19:35 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is this column provides information about the job run duration.
Only when job has only run one time only.
Run job a second time TOTAL_TIME will be sum of both runs; first & second runs.

Report message to a moderator

Previous Topic: neede help with oracle partitioning installation
Next Topic: Troubleshooting job scheduling
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 10:45:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.