Re: DBMS_JOB PACKAGE - Pls Help Me

Hi Akhilesh,

Here is an example:


DECLARE
  X NUMBER;
BEGIN
  SYS.DBMS_JOB.SUBMIT
    ( job       => X
     ,what      => 'your_procedure;'
     ,next_date => to_date('03/10/2008
10:35:41','dd/mm/yyyy hh24:mi:ss')
     ,interval  => 'sysdate + 1 / (24 * 60)'
     ,no_parse  => TRUE
    );
  SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' ||
to_char(x));
END;
/

commit;


Assuming your running your database on windows, make sure
the 
OracleJobScheduler service is running.

Mike.

----- Original Message ----- 
To: "Multiple recipients of list ODTUG-SQLPLUS-L"

<ODTUG-SQLPLUS-Lfatcity.com>
Sent: Friday, October 03, 2008 10:45 AM


>
> Hi,
>
> This is Akhilesh, I am not able to execute my
scripts/procedure at exact 
> time I mean on specific time in seconds like (HH:MI:SS)
05:59:59 AM. I am 
> able to execute it at 05:59 I mean not in seconds, thru
Windows Task 
> Scheduler.
>
> Can somebody is having a example of scheduler thru
DBMS_JOB PACKAGE ?
> If yes please help and send me the procedure
step-by-step.
>
> Thanking You
> Akhilesh
>
>
>
>
> --
> Will the all new Indica Vista zip ahead of the Suzuki
Swift? Read the 
> expert review on Zigwheels.com
> http://zigwheels.com/b2cam/reviewsDetails
.action?name=Ro11_20080829&path=/INDT/Reviews/Ro11_20080
829&page=1&pagecount=9
> -- 
> For more information on this topic or to become a
member, visit our Web 
> site at http://www.ODTUG.com
>
> Join ODTUG for The PL/SQL and The APEX Expert Gathering
of the Year! 
> OPP2008 and APEXposed! 2008 will be held on October
29-30, 2008 at the 
> Wyndham O'Hare, Chicago. Visit www.odtugopp.com or 
> www.odtugapextraining.com for more details.
>
>
> -- 
> Author:
>  INET: sendakhileshindiatimes.com
>
> Fat City Hosting, San Diego, California -- http://www.fatcity.com
>
------------------------------------------------------------
---------
> To REMOVE yourself from this mailing list, send an
E-Mail message
> to: ListGurufatcity.com (note EXACT spelling of
'ListGuru') and in
> the message BODY, include a line containing: UNSUB
ODTUG-SQLPLUS-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).
> 

-- 
For more information on this topic or to become a member,
visit our Web site at http://www.ODTUG.com  

Join ODTUG for The PL/SQL and The APEX Expert Gathering of
the Year! OPP2008 and APEXposed! 2008 will be held on
October 29-30, 2008 at the Wyndham O'Hare, Chicago. Visit
www.odtugopp.com or www.odtugapextraining.com for more
details.


-- 
Author: Mike Barratt
  INET: mikeodtugf2s.com

Fat City Hosting, San Diego, California -- http://www.fatcity.com
------------------------------------------------------------
---------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGurufatcity.com (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB
ODTUG-SQLPLUS-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).