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
How do you use join?
What is sap sql anywhere?
Which command is used to call a stored procedure?
what is the command line end user interface - mysql? : Sql dba
What is a boolean in sql?
what is try_catch block in procedure
What are all ddl commands?
What is linq to sql?
What are the packages in pl sql?
How do I access sql anywhere database?
What are data types in pl sql?
What is sql select statement?
what are rollup and cube in t-sql? : Transact sql
Explain locks? : Transact sql
What is parallel hint?