O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Job Scheduling

With SQL Server, the msdb database holds the information about jobs and schedules, and the SQL Server Agent service must be running for the jobs to be executed. It logs the information about the jobs and maintains a history of successful runs and failed jobs with errors. The jobs also can be extracted from SQL Server and created on another server.

In Oracle, the Oracle Scheduler handles job scheduling. PL/SQL and Java procedures can be scheduled, as well as scripts outside the database, such as shell scripts and executables. The Oracle Scheduler has an interface in OEM. Using the DBMS_SCHEDULER package, you can schedule jobs and get job information from the command line. The jobs are logged, and since Oracle Database 10g R2, they ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required