SchedOra is a lightweight application that was designed to simplify the work of database administrators and help them create, organize and schedule jobs within Oracle Scheduler. Users can benefit from SchedOra's functions without needing to know any SQL-specific queries, as the intuitive Graphical User Interface (GUI) makes it possible. The interface also features support for a large variety of Oracle Scheduler items, including calendar syntax features, SCHEDULE, JOB and PROGRAM.
Aside from the ones mentioned above, this program helps database administrators better organize their content by providing them with multiple indicators for existing entries. For instance, jobs are displayed in grids or schema trees and they feature an indicator icon so that users can identify the current state of an entry easier, be it broken, disabled or active.
Additionally, it also allows admins to view detailed resource consumption values for every job, thus helping them keep high-consuming tasks under a certain threshold. More so, it features an Executable File Wizard that allows generating Batch based programs in an effortless manner. Otherwise, doing so manually can be challenging as the batch file comes with numerous arguments.
It features a wide variety of tools that users can use for job monitoring, organization and editing, depending on their need. More so, the dialogs and wizard-like menus help administrators achieve the desired results in a faster manner since they do not need to waste time looking for specific functions. Every process relies on the DBMS_SCHEDULER package from Oracle scheduler, therefore providing users with a wide range of capabilities.