By using dbms_job (buitin package upto oracle 9i) and using dbms

How can we schedule the procedure to run automatically ?

Question Posted / mahesh

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How does an execution block start and end in pl sql?

950

how can we know the number of days between two given dates using mysql? : Sql dba

1046

Can a composite key be null?

972

what is sp_pkeys? : Transact sql

1150

What are some predefined exceptions in pl/sql?

1167

Why self join is used in sql?

974

What is normalization? How many normalization forms are there?

1080

Advantages and disadvantages of stored procedure?

1120

Why do we use procedures in sql?

1072

What is the difference between delete and truncate statement in sql?

1068

What are different types of functions in sql?

1004

Which language is used in sql?

1052

Does sql profiler affect performance?

987

How do you identify a primary key?

1062

what is 'mysqlcheck'? : Sql dba

1011