how can you schedule a job in database?



how can you schedule a job in database?..

Answer / Sandeep Aswal

Scheduling jobs in an Oracle database can be done using DBMS_SCHEDULER package, which allows for the creation and management of recurring and one-time tasks. These jobs can be set to run SQL scripts, PL/SQL blocks, or external programs.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1 Answers  


how can you find out if a table can be redefined?

1 Answers   Oracle,


what is incremental checkpoint?

1 Answers   CTS,


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1 Answers   EDS,


what is grd?

1 Answers   Oracle,


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1 Answers  


What is a correlated sub-query? : sql server DBA

1 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


What the different topologies in which replication can be configured? : sql server DBA

1 Answers  


Datapump backup steps?

1 Answers  


Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


why do we give pctfree and pctused in create table statement?

1 Answers   CTS,


Categories