| DBMS_JOBS [message #69666] |
Thu, 14 February 2002 12:08  |
Radhika
Messages: 12
Registered: June 2001
|
Junior Member |
|
|
I want to run my procedure every day at 6:00PM.
I am working on oracle 8i in windows 2000 environment
Can anyone help me with that.
|
|
|
|
| Re: DBMS_JOBS [message #69667 is a reply to message #69666] |
Thu, 14 February 2002 18:59  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
declare
jobno number;
begin
dbms_job.submit(jobno,'proc_name;',to_date('02/15/2001 18:00:00','mm/dd/yyyy hh24:mi:ss'),
'trunc(sysdate)+3/4');
commit;
end;
|
|
|
|
| Re: DBMS_JOBS [message #69670 is a reply to message #69667] |
Thu, 14 February 2002 23:26 |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
variable jobno number
begin
dbms_job.submit(:jobno,'my_procedure;',sysdate,
'trunc(sysdate + 1' + 18/24');
end;
/
Your job will execute immediately. If you do not want it, please change the
sysdate in first parameter accordingly. Do not change the second parameter.
you can check the status with the following sql:
select job, to_char(next_date,'DD-MON-YYYY HH24:MI'),
to_char(last_date,'DD-MON-YYYY HH24:MI'), interval, failures, broken from
all_jobs;
Regards,
Vikas.
vicky@icenet.net
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
