How can we schedule the procedure to run automatically ?

Question Posted / swapna

3 Answers
11046 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we schedule the procedure to run automatically ?..

Answer / mahesh

By using dbms_job (buitin package upto oracle 9i)
and using dbms_scheduler (oracle 10G onwrds)

Is This Answer Correct ?

7 Yes

0 No

How can we schedule the procedure to run automatically ?..

Answer / nakul.v

We can Schedule a Stored Procedure to run automatically
once we attach the Procedure to a Package and use the
Built – In DBMS_JOB Package.
DBMS_JOB.SUBMIT & DBMS_JOB.RUN will help us to Schedule a
Stored Procedure

Is This Answer Correct ?

4 Yes

0 No

How can we schedule the procedure to run automatically ?..

Answer / swapna

We Can Schedule The Procedure Run Automatically By Using
Packages.

Is This Answer Correct ?

6 Yes

5 No

Post New Answer

More SQL PLSQL Interview Questions

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers DELL, HCL, Oracle,

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers HSBC,

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers Cognizant,

which operator is used in query for pattern matching? : Sql dba

0 Answers

What is a temp table?

0 Answers

What is cost in sql execution plan?

0 Answers

How to handle bulk data?

0 Answers

What will you get by the cursor attribute sql%notfound?

0 Answers

What is the difference between sum and count in sql?