-
dbms_job
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')
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
-
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.
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?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
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"
-nagarjuna
-
Last edited by abhaysk; 03-15-2003 at 05:48 AM.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Originally posted by nagarjuna
Do you know the difference between sysdate and SYSDATE
Let me guess please! You must press CapsLock if you want to use SYSDATE. Tell me I am right, please, please, please :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
lol @Julian
mike > Try as I said and post us the result.
-nagarjuna
-
Originally posted by nagarjuna
lol @Julian
mike > Try as I said and post us the result.
nagarjuna :
Be logical.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
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
|