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 ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.