how can I schedule this job to be run a 10:00pm everyday ???
EXECUTE dbms_job.submit(:x,'procedure_name;',sysdate,'sysdate+1')
commit;
thanks
Printable View
how can I schedule this job to be run a 10:00pm everyday ???
EXECUTE dbms_job.submit(:x,'procedure_name;',sysdate,'sysdate+1')
commit;
thanks
EXECUTE dbms_job.submit(:x, 'procedure_name;', TRUNC(sysdate)+22/24, 'TRUNC(sysdate)+1+22/24')
thanks Jmodic
the job was ran last night and I look into the NEXT_DATA column and it still show the date of yesterday which is 03/14/2003, I thought it has to be 03/15/2003 instead.
I don't know which time zone are you in, but here in Europe today is still 03/14/2003. I'm guessing you are in western hemisphere, so I think "your today" must also be 03/14/2003, not 03/15/2003, no? I guess something must be wrong with your callendar. Or am I wrong?Quote:
Originally posted by mike2000
the job was ran last night and I look into the NEXT_DATA column and it still show the date of yesterday which is 03/14/2003, I thought it has to be 03/15/2003 instead.
Do you know the difference between sysdate and SYSDATE while using dbms_job package???Quote:
Originally posted by mike2000
thanks Jmodic
the job was ran last night and I look into the NEXT_DATA column and it still show the date of yesterday which is 03/14/2003, I thought it has to be 03/15/2003 instead.
sysdate => the time you submitted the job.
SYSDATE => the time the job was run last.
For mroe details refer "Oracle8i Supplied PL/SQL Packages Reference"
:oQuote:
Originally posted by nagarjuna
sysdate => the time you submitted the job.
SYSDATE => the time the job was run last.
Well havent used DBMS_JOB...but
It does'nt make sense to keep the date/time as SYSdate then....:rolleyes:
SYSdate=SYSDATE=sysdate= OS system date ( if i think logically ).
Guys i may be wrong ... in case correct me ;) .
Abhay.
?????Quote:
Originally posted by nagarjuna
Do you know the difference between sysdate and SYSDATE while using dbms_job package???
sysdate => the time you submitted the job.
SYSDATE => the time the job was run last.
For mroe details refer "Oracle8i Supplied PL/SQL Packages Reference"
Wat are you talking about?
Let me guess please! You must press CapsLock if you want to use SYSDATE. Tell me I am right, please, please, please :-)Quote:
Originally posted by nagarjuna
Do you know the difference between sysdate and SYSDATE
lol @Julian
mike > Try as I said and post us the result.
nagarjuna :Quote:
Originally posted by nagarjuna
lol @Julian
mike > Try as I said and post us the result.
Be logical.
Abhay.