OraFAQ Forum: Server Administration » how many times has been executes a job?

Home » RDBMS Server » Server Administration » how many times has been executes a job? (oracle 10g)

Fri, 26 November 2010 05:44

iblazquez
Messages: 26
Registered: June 2007

Junior Member

Can anybody tell me how can I know the total times a job has been executed

Thanks

Fri, 26 November 2010 05:46

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

DBA_JOBS.TOTAL_TIME.

Regards
Michel

Fri, 26 November 2010 05:54

iblazquez
Messages: 26
Registered: June 2007

Junior Member

But TOTAL_TIME is in seconds ¿no? I need the times.

Fri, 26 November 2010 05:55

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You mean the number of times?
There is no way to know it. Record it in your job.

Regards
Michel

Fri, 26 November 2010 05:57

iblazquez
Messages: 26
Registered: June 2007

Junior Member

and when was the first execution?

Thanks Michel

Fri, 26 November 2010 07:35

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

All available information are in dba_jobs.

Regards
Michel

Previous Topic:	broken link
Next Topic:	TNS protocol adapter error

Goto Forum:

]

Current Time: Sun May 12 03:41:34 CDT 2024