Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we schedule the procedure to run automatically ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are integrity rules?

1022


how to extract a unit value from a date and time? : Sql dba

990


What are aggregate and scalar functions?

1015


Explain architecture of sql server notification services?

1054


what is the difference between sql and t-sql? : Transact sql

1084


how many ways we can we find the current date using mysql? : Sql dba

1095


How do you create a db file?

1011


can sql servers linked to other servers like oracle? : Sql dba

1005


What do you think about pl/sql?

1023


How can you load multi line records? : aql loader

1071


What is indexing oracle sql?

1097


What is the purpose of a secondary key?

962


What is dialect in sql?

942


What are tables and fields in the database?

1104


What is package in pl sql with an examples?

1035