Phone (800) 766-1884 for immediate Oracle support & training
Free Oracle Tips

Home Home
Oracle Monitoring
Growth Monitoring
Emergency DBA Support
Installs & Upgrades
Oracle Migration
Oracle Support Plan
Oracle SQL Tuning
Oracle Performance Tuning

 Our Remote DBA Clients

 

Free Oracle Tips


 
HTML Text

Free Oracle App Server Tips


 
HTML Text

 

   
  Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 1 - Overview of Oracle Job Scheduling

AT.EXE

Jobs can be deleted using the /delete option:

C:\>at 1 /delete

C:\>at 2 /delete

C:\>at
There are no entries in the list.

C:\>

The AT scheduler has been at the heart of Windows scheduling for some years, but recent Windows versions have introduced simpler and more flexible alternatives, which will be covered in the following section.

Scheduled Tasks Wizard

In Windows 2000, Windows XP, and Windows 2003 there is a GUI tool called the Scheduled Tasks Wizard, which is far more convenient than the AT command.  It is available from the Control Panel or from the task bar (Start  - Programs  - Accessories - System Tools  - Scheduled Tasks).  The resulting dialog lists the current scheduled tasks and an Add Scheduled Task icon, as seen in Figure 1.1.

Figure 1.1Scheduled Tasks dialog with no scheduled jobs

 

To schedule a new task, simply double click on the Add Scheduled Task icon, which starts the Scheduled Tasks Wizard as shown in Figure 1.2.

Figure 1.2Scheduled Tasks Wizard


The above text is an excerpt from:


Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall
 

http://www.rampant-books.com/book_2005_1_scheduling.htm


    Need an Oracle Health Check?

Does your boss blame you for an Oracle performance problem? 
Need to prove that your database is properly optimized?

BC Oracle performance guru's can quickly verify every aspect of your Oracle database and provide a complete certification that your database is fully optimized.

Burleson Oracle consulting & training



 

 

WISE Oracle monitoring software
 

 

Oracle forum for DBA 

 

Rampant TechPress Oracle book publisher

image 

  

 

E-mail us for BC Oracle support:   

Copyright © 1996 -  2012 by Burleson Enterprises. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.