set a schedule date time in DBMS_JOB.SUBMIT [message #609528] |
Sun, 09 March 2014 06:56 |
meteo
Messages: 89 Registered: April 2010 Location: beirut
|
Member |
|
|
i write the following procedure
procedure P_SUBMIT_P99_JOB
AS
start_app_auto NUMBER := 0;
BEGIN
DBMS_JOB.SUBMIT (start_app_auto, ' begin P80_FINAL_PROC_AUTO_COLL_MTR ; end; ' , ' 10-MAR-14 02.05 PM ', ' TRUNC(10-MAR-14 02.05 PM + (05/24/60),' 'MI' ') ');
END;
i want the schedule for this procedure to run at '10-MAR-14 02.05 PM' and re run for each 5 minutes for ever
when i run this procedure using isqlplus
exec P_SUBMIT_P99_JOB ;
i m getting the following error
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
ORA-06512: at "METEO.P_SUBMIT_P99_JOB", line 8
ORA-06512: at line 1
how can i set the date time parameter in DBMS_JOB.SUBMIT to get the true mentioned schedule??
thank you.
|
|
|
Re: set a schedule date time in DBMS_JOB.SUBMIT [message #609531 is a reply to message #609528] |
Sun, 09 March 2014 09:46 |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
In your call here,
Quote:DBMS_JOB.SUBMIT (start_app_auto, ' begin P80_FINAL_PROC_AUTO_COLL_MTR ; end; ' , ' 10-MAR-14 02.05 PM ', ' TRUNC(10-MAR-14 02.05 PM + (05/24/60),' 'MI' ') ');
the part I've made red is a string that you need to convert to a date and the part in blue isn't even a string because it isn't quoted.
|
|
|