By using Task Scheduler, you can schedule tasks such as to automate web testing and site monitoring or system tools like the Disk Defragmenter to run at a time that is most convenient for you. Task Scheduler starts each time you start Windows, and runs in the background. With Task Scheduler, you can: Schedule a task to run daily, weekly, monthly, or at certain times (such as system startup).
On Windows XP and Server 2003 you can access this from the Start Menu and clicking on Settings and then Control Panel to Scheduled Tasks.
Windows administrators can easily manage Scheduled Tasks using command line utility named schtasks.exe which is available in Windows XP/2003/7/2008/2008 R2 operating systems.
Create a scheduled task to run notepad at 8:00AM every day:
C:\>schtasks /create /TN "Run notepad" /TR notepad.exe /SC DAILY /ST 08:00:00
Note: Here in above example, we are mentioning any user account. But the command execution will try to configure scheduled account with current logged on user and prompts you to enter the password.
In case, you want to create a scheduled task with specific user account, pass them as command arguments.
C:\>schtasks /create /TN "Run notepad" /TR notepad.exe /SC DAILY /ST 08:00:00 /RU domain\username /RP xxxxxx
We are done with creating scheduled tasks. Now, let’s see how to list the Scheduled Tasks running in local system as well as remote
Query list of scheduled tasks running in local computer.
C:\>schtasks /query
This lists all the scheduled tasks running in local computer.
e.g.
C:\>schtasks /query
TaskName Next Run Time Status
==================================== ======================== ===============
GoogleUpdateTaskMachineCore At logon time
GoogleUpdateTaskMachineCore Never
GoogleUpdateTaskMachineUA Never
Run a scheduled task manually:
If we want to run a scheduled task manually irrespective of it’s schedule, we can do it easily like below.
C:\>schtasks /run /TN “Run notepad”
This triggers the command which is configured in scheduled task(notepad in our example).
Modifying scheduled task:
Now we will see how to modify scheduled tasks. We will be able to modify only few parameters using this utility like, program to run, username, password used by scheduled task. Let’s see how we can change the program to run.
C:\> schtasks /change /TN "Run notepad" /TR cmd.exe
In this example, we have changed the program to run from notepad.exe to cmd.exe
Deleting scheduled tasks:
Below are the few examples which describes usage of delete option.
Examples:
SCHTASKS /Delete /TN * /F
SCHTASKS /Delete /TN "Backup and Restore"
As you can see in above example, /F option forces the delete. This is generally required if a scheduled task is not responding or in running state.
Stop a running scheduled task:
If a scheduled job is running for long time and want to stop it, we can use /END parameter. Now lets see a example how to end a scheduled task
C:\>schtasks /END /TN "Run notepad"
If you want to perform any of the above operations on a remote system, use the parameter /S in the command. For example, to query list of tasks scheduled in remote machine use the below command.
C:\>schtasks /query /S remotehost
e.g.
C:\>schtasks /query /s Remoteservername
TaskName Next Run Time Status
==================================== ======================== ===============
backup 02:00:00, 10/6/2010
DeleteSQLBackup7old 23:00:00, 10/10/2010
SQLVesrionControl Never
SQLVesrionControl 23:00:00, 10/5/2010
VSSToDev2000 Never
This blog is useful for Database, Business Intelligence, Bigdata and Data Science professionals.
Subscribe to:
Post Comments (Atom)
Secure a Microsoft Fabric data warehouse
Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transa...
-
Database Mirroring and index maintenance in AWS Database Mirroring, the database has to be in the full recovery mode, so all index rebuilds...
-
This post contains examples of a number of the most commonly performed DBA activities. They are all listed in alphabetical order by the comm...
-
Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...
1 comment:
hi!This was a really excellent topic!
I come from roma, I was fortunate to discover your subject in digg
Also I obtain a lot in your website really thanks very much i will come every day
Post a Comment