Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB running history
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
dba.orcl_at_gmail.com wrote:
> Is there an easy way to maintain/check history of DBMS_JOB?
> We have a snapshot refresh job scheduled for every 5 mins. Sometime it
> takes 2 mins to complete , sometime it takes 7 mins.
>
> We like to get an average time to refresh (based on all the runs in a
> single day).
>
> Any comments?
>
> Sami
>
What's wrong with your 5 minutes schedule, then?
- --
Regards,
Frank van Bortel
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCVnkofyJ9XXMPY5URAmRCAJ4wgoYJF+qnXtDXng46iKPrJBzjZACbBmga
W0kkFYUwR83QSyUBJHN1Qgo=
=hvLq
-----END PGP SIGNATURE-----
Received on Fri Apr 08 2005 - 07:29:28 CDT