This is how you shedule job
Regards
Rohit

variable jobno number;
variable instno number;
begin
select instance_number into :instno from v$instance;
dbms_job.submit(:jobno, 'jobwhichyouwanttorun', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/1,''HH'')', TRUE, :instno);
commit;
end;

-----Original Message-----
From: Sood Ankit (GE Consumer Finance consultant) [mailto:oracledba-ezmlmshield-x17407325.[Email address protected]
Sent: Friday, July 30, 2004 2:50 PM
To: LazyDBA Discussion
Subject: RE: dbms_jobs

Hi ,
tell me how to do it i mean the command

-----Original Message-----
From: Rawat Rohit (Path)
[mailto:oracledba-ezmlmshield-x11829797.[Email address protected]
Sent: Friday, July 30, 2004 6:17 PM
To: LazyDBA Discussion
Subject: RE: dbms_jobs


Ankit ,
Submit your job using dbms_job.submit package.
Regards
Rohit


-----Original Message-----
From: Sood Ankit (GE Consumer Finance consultant) [mailto:oracledba-ezmlmshield-x93818688.[Email address protected]
Sent: Friday, July 30, 2004 2:44 PM
To: LazyDBA Discussion
Subject: dbms_jobs

Dear all ,
I want to schedule a job which run every day at 5:30 in the evening.Please tell me the steps in Oracle.
Regards
Ankit



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




=================================================
Disclaimer : The information contained in this Message is confidential and intended only for the use of the individual or entity identified. If the reader of this message is not the intended recipient, any dissemination, distribution or copying of the information contained in this message is strictly prohibited. If you received this message in error, please notify the sender immediately.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




=================================================
Disclaimer : The information contained in this Message is confidential and intended only for the use of the individual or entity identified. If the reader of this message is not the intended recipient, any dissemination, distribution or copying of the information contained in this message is strictly prohibited. If you received this message in error, please notify the sender immediately.

Oracle LazyDBA home page