Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle schtasks.exe tips

Oracle Database Tips by Donald BurlesonApril 30, 2015

Using the Windows Job Scheduler SCHTASKS.EXE

The SCHTASKS command was introduced in Windows XP and Windows 2003 as a more flexible and slightly more verbose replacement for the AT command. The AT command is still available for backwards compatibility, but it is no longer the preferred command line scheduling method.

The SCHTASKS command provides a command line API for situations in which a command line approach is preferable.

The usage notes for the SCHTASKS command are very comprehensive and include examples as well as basic syntax. The top-level usage notes are displayed below with examples indicating how more parameter specific usage notes can be obtained.


SCHTASKS /parameter [arguments]


Enables an administrator to create, delete, query, change, run and

end scheduled tasks on a local or remote system. Replaces AT.exe.

Parameter List:

/Create Creates a new scheduled task.

/Delete Deletes the scheduled task(s).

/Query Displays all scheduled tasks.

/Change Changes the properties of scheduled task.

/Run Runs the scheduled task immediately.

/End Stops the currently running scheduled task.

/? Displays this help/usage.






SCHTASKS /Create /?

SCHTASKS /Delete /?

SCHTASKS /Query /?

SCHTASKS /Change /?

To schedule a job that runs the c:\jobs\MyJob.bat script at 9:00 p.m. on Mondays, Tuesdays, Thursdays and Fridays, the following commands would be used:

SCHTASKS /Create /TN MyJob /TR C:\Jobs\MyJob.bat /ST 21:00:00 /SC weekly /D MON,TUE,THU,FRI

The task will be created under current logged-on user name ("tim_hall").

Please enter the run as password for tim_hall: ******

SUCCESS: The scheduled task "MyJob" has successfully been created.

Once a task is created, it can be viewed by issuing the SCHTASKS command with no parameters:


TaskName Next Run Time Status

==================================== ========================

MyJob 21:00:00, 04/06/2004

Tasks that are no longer needed can be deleted using the /delete option:

C:\>SCHTASKS /delete /TN MyJob

WARNING: Are you sure you want to remove the task "MyJob" (Y/N )? y

SUCCESS: The scheduled task "MyJob" was successfully deleted.


INFO: There are no scheduled tasks present in the system.

Since some of the external schedulers available on the most common operating systems have been presented, the following section will focus on the internal schedulers provided by the Oracle database.

Get the Complete
Oracle SQL Tuning Information 

The landmark book "Advanced Oracle SQL Tuning  The Definitive Reference"  is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster