Chapter 1 -
Overview of Oracle Job Scheduling
||Oracle Tips by Burleson
Jobs can be deleted using the /delete option:
C:\>at 1 /delete
C:\>at 2 /delete
There are no entries in the list.
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 – Scheduled Tasks dialog with no
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.2 – Scheduled Tasks Wizard
||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.