ABSTRACT
Oracle Database includes a job scheduler. It can schedule jobs to run at a designated date and time. Though the Scheduler also includes chains, which are named groups of steps that work together to accomplish a task, there are some disadvantages: job dependency is not easy to set, job concurrency is not manageable, and it has no notice by text-message. The researchers designed, built and tested the Dependency Execution for Oracle Jobs for a long time. It is running smoothly after trial and trial. It is much easy to set a job which depends on other jobs by inserting a row into a configuration table, and the job can be scanned and run by background processes which are designed by researchers. On this way, this system can also record who is the job's creator, how to contact, and the time of created and estimated expires. It has concurrency control and the priority and private channel for the jobs execution of short time. Many companies have a lot of reports to do every day. It depends on the data from all over the systems to be extracted and processed. The database is so stressed every morning that it is needed to property schedule job execution. The designed system shall make a more convenient and easier configuration to create and rerun Oracle jobs. The system administrators can also analysis the log to remind the job creator to optimize the script and improve the execution efficiency and performance of the Oracle database.
- Oracle help center. 2018. 26 Scheduler Concepts of Database Administrator's Guide, https://docs.Oracle.com/cd/B19306_01/server.102/b14231/schedover.htm#sthref3496.Google Scholar
- Chris Ruel, Michael Wessler,How to Create a Scheduler Job in Oracle 12c, https://www.dummies.com/programming/databases/how-to-create-a-scheduler-job-in-Oracle-12c/.Google Scholar
- Oracle-base, 2018. Scheduler in Oracle Database 10g, https://Oracle-base.com/articles/10g/scheduler-10g.Google Scholar
- Oracle help center, 2018. Scheduling Jobs with Oracle Scheduler, https://docs.Oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN034.Google Scholar
- Pavan, Feb. 2017. Oracle Job Scheduler Guide With Examples, https://www.opencodez.com/Oracle/Oracle-job-scheduler-guide-examples-part-1.htm.Google Scholar
- Augusdi, April 2015. Job Dependency, https://blog.csdn.net/augusdi/article/details/44853787.Google Scholar
- Augusdi. April 2015. Job dependency scheduling, https://www.ibm.com/support/knowledgecenter/en/SSETD4_9.1.3/lsf_admin/job_dep_sched.html.Google Scholar
- Synopsys, Inc. 2018. Synopsys Top 4 software development methodologies, https://www.synopsys.com/blogs/software-security/top-4-software-development-methodologies/.Google Scholar
- Rodrigo Escobar, Rajendra V. Boppana. 2016. Performance Prediction of Parallel Applications Based on Small-Scale Executions. 2016 IEEE 23rd International Conference on High Performance Computing (HiPC).Google Scholar
- Augusdi, April 2015. Oracle Dependency Management, https://docs.Oracle.com/cd/A84870_01/doc/server.816/a76965/c19depnd.htm.Google Scholar
Index Terms
- Designing a Dependency Execution for Oracle Jobs
Recommendations
Scheduling jobs under decreasing linear deterioration
This paper considers the scheduling problems under decreasing linear deterioration. Deterioration of a job means that its processing time is a function of its execution start time. Optimal algorithms are presented respectively for single machine ...
Scheduling of deteriorating jobs with release dates to minimize the maximum lateness
In this paper, we consider the problem of scheduling n deteriorating jobs with release dates on a single (batching) machine. Each job's processing time is a simple linear function of its starting time. The objective is to minimize the maximum lateness. ...
Single machine parallel-batch scheduling with deteriorating jobs
We consider several single machine parallel-batch scheduling problems in which the processing time of a job is a linear function of its starting time. We give a polynomial-time algorithm for minimizing the maximum cost, an O(n5) time algorithm for ...
Comments