PL/SQL - Job scheduling

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 141 of 166

Job scheduling

How can i schedule a procedure every day at 10 pm

Total Answers and Comments: 1

Last Update: August 13, 2008 Asked by: ramesh.akula9

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 13, 2008 01:42:25

rajivgupta780184

Member Since: August 2008 Contribution: 32

RE: Job scheduling

This is the sample code you have to adjust time according to your requirement

SET AUTOPRINT ON
VAR jobno NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:jobno 'JOBNAME;' TRUNC(SYSDATE) + 6/24
'TRUNC(SYSDATE + 1) + 6.183/24');
COMMIT;
END;

Thanks
Rajiv
Gupta
Yogik Technologies Pvt. Ltd.

Is this answer useful? Yes | No

The Importance Of Scheduling For Time Management

The Importance Of Scheduling For Time Management Once you have set goals to achieve something you will need to begin properly managing your time in order to work towards these goals After you have created a To Do list you will next need to create a schedule which will allow you to complete all the i

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th

User Name		Remember Me?
Password

Question Bank

The Importance Of Scheduling For Time Management

Be Prepared for Tech Job Cuts