-
dbms_scheduler time problem
Hi There, i have been trying to set up a job to run through dbms_scheduler fpr the first time. Everything appears to load in ok but when i check dba_scheduler_jobs the date looks like scheduled for 2020 rather than 2009
Note this is just a test to get working, i am not actually only going to run this once on a friday, just need to see it work first before tailoring.
Code:
begin
dbms_scheduler.create_schedule(
schedule_name => 'phil_schedule'
,start_date => '08/MAY/2009 12:00:00'
,repeat_interval => 'FREQ=WEEKLY'
, comments => 'Weekly on Fri at 12');
END;
/
begin
dbms_scheduler.create_job
(
job_name => 'ifstest_statspack',
schedule_name => 'phil_schedule',
job_type => 'EXECUTABLE',
job_action => '/home/oracle/statspack/scripts/ifstest-statspack.sh',
enabled => true,
comments => 'Run shell-script'
);
end;
/
I have had this set and the time comes and goes and nothing happens. I go to check dba_scheduler_jobs and it tells me that the start date is the following
08-MAY-20 09.12.00.000000 +01:00
That looks like 2020 to me
if i try creating the schedule with dates in format
start_date => '08/MAY/09 12:00:00'
or
start_date => '2009/MAY/08 12:00:00'
i get errors about date too short or invalid month
I just want to check i am not barking up the wrong tree, that does say 2020 yeah? What do i do to fix this?
I have read i could set NLS_DATE_FORMAT but this could interfere with other things (other peoples scripts?)
Anyone have any suggestions?
Thanks in advance.
ps this is Oracle 10.2.0.1 on Solaris 10
P
-
To_date()
Try:
Code:
-- Etc --
,start_date => TO_DATE('08/MAY/2009 12:00:00','DD/MM/YYYY HH24:MI:SS')
-- Etc --
PS: Not sure if you need outer single or double or no quotes.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by LKBrwn_DBA
Try:
Code:
-- Etc --
,start_date => TO_DATE('08/MAY/2009 12:00:00','DD/MM/YYYY HH24:MI:SS')
-- Etc --
PS: Not sure if you need outer single or double or no quotes.
Thanks, that worked just as you wrote it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|