Thanks David, big help!
Abdul Latif
--- "David A. Barbour" <dbarbour_at_nucentrix.net> wrote:
> dba_jobs Lists all the jobs in the database.
> user_jobs Lists all jobs owned by the user.
> dab_jobs_running Lists all jobs in the database
> that are currently
> running (join with V$LOCK to identify jobs that have
> locks).
>
> Hope this helps.
>
> David A. Barbour
> Oracle DBA, OCP
>
> abdul latif wrote:
> >
> > Raj,
> >
> > Which view do you use to view dbms_jobs?
> >
> > tia
> > --- "Jamadagni, Rajendra"
> > <rajendra.jamadagni_at_espn.com> wrote:
> > > Yes, I have used with very good success ....
> it's
> > > all documented in T(ht)
> > > F(ine) M(anual). Or just open up
> > > $ORACLE_HOME/rdbms/admin/dbmsjob.sql ...
> > > this file itself is pretty good at explaining
> > > things.
> > >
> > > HTH
> > > Raj
> > >
> >
>
> > > Rajendra Jamadagni MIS, ESPN Inc.
> > > Rajendra dot Jamadagni at ESPN dot com
> > > Any opinion expressed here is personal and
> doesn't
> > > reflect that of ESPN Inc.
> > >
> > > QOTD: Any clod can have facts, but having an
> opinion
> > > is an art !
> > >
> > >
> >
>
> > >
> > > This e-mail message is confidential, intended
> only
> > > for the named recipient(s) above and may contain
> > > information that is privileged, attorney work
> > > product or exempt from disclosure under
> applicable
> > > law. If you have received this message in error,
> or
> > > are not the named recipient(s), please
> immediately
> > > notify ESPN at (860) 766-2000 and delete this
> e-mail
> > > message from your computer, Thank you.
> > >
> > >
> >
>
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Jamadagni, Rajendra
> > > INET: rajendra.jamadagni_at_espn.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> >
>
> > > To REMOVE yourself from this mailing list, send
> an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be
> removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Auctions - buy the things you want at great
> prices
> > http://auctions.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: abdul latif
> > INET: abdulatif52_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: David A. Barbour
> INET: dbarbour_at_nucentrix.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: abdul latif
INET: abdulatif52_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Apr 29 2001 - 19:54:39 CDT
