Thanks David, big help!
Abdul Latif
--- "David A. Barbour" <[EMAIL PROTECTED]> wrote:
> dba_jobsLists 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 identif
dba_jobsLists 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"
<[EMAIL PROTECTED]> 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
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
E-L
> Subject: RE: Urgent: How to Automate Procedure Execution
>
> Do you know the syntax?
>
> --- "Jamadagni, Rajendra"
> <[EMAIL PROTECTED]> wrote:
> > You can use dbms_job to achieve this ...
> >
> > Raj
> >
> _
Do you know the syntax?
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> You can use dbms_job to achieve this ...
>
> Raj
>
__
> Rajendra JamadagniMIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed
You can use dbms_job to achieve this ...
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, bu
Check out this package dbms_job!
Hitarth Trivedi
Oracle Certified DBA (7.3)
Sun Certified Java 2 Programmer
MCSE, MCP+I
315-362-1162
[EMAIL PROTECTED]
-Original Message-
From: abdul latif [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 2
You can write a batch/shell script , which connects to the database and
executes your procedure. Then you can use at(in NT)/ crontab (in UNIX) to
call that script at 10 PM...
Uday
-Original Message-
Sent: Friday, April 20, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L
Listers,
