24x7 Script Archive


Free command line utilities

BindCPU If you run applications on a multiprocessor machine you can use this utility to bind a particular application to a particular CPU. By binding different applications to different CPUs you can greatly optimize your application performance.
 
BindDesktop Using this utility you can run different applications on different virtual desktops. For example if you run 24x7 Scheduler in Windows NT service mode (Windows NT/2000/XP/2003/Vista runs all services on the invisible services desktop) you can use BindDesktop to run a process on a visible user Desktop allowing users to see and interact with the process. By default all child processes always run on the desktop where the parent process is started. BindDesktop provides a solution to this issue.
 
SetPriority Change process priority of a running process. This utility can be used on Windows NT/2000/XP/2003/Vista systems.
 
FileCopy DOS copy command, Windows Explorer file copy operations, JAL's FileCopy statement, VBScript's CopyFile method, Windows API FileCopy functions; all of them have the same common deficiency - they lock files during file copy operations. As a result, you can experience various file sharing problems if you schedule multiple jobs that use the same file. The FileCopy utility allows non-locking file copying as well as partial and incremental file copying.
 
LineCount Use LineCount to count lines in your source code files or use it to verify integrity of your data files.
 
LineCopy This utility provides for Windows what head and tail utilities provide for Unix systems. LineCopy performs line-based copying of text files allowing one to copy and extract portions of a text file or cut a text file into pieces. Files are copied in shared read-write mode so that they can be accessible for read and update by other programs during LineCopy processing.
 
FileDir This multi-file processor utility extends functionality of the DOS dir command. Two main extensions:
1. File date and age filters (for example, you can find files that are older than N number of days)
2. Automatic processing of each found file by a program of your choice (for example, to delete all log files from a particular directory that are more that 30 days old, you can run
FileDir /C cmd /P "/c del " /A 30 /N *.log).
 
FileTouch Windows keeps track of the date and time every file was created, and of the date and time it was last modified or accessed, but it does not provide ways for changing file dates and times manually without modifying the actual files. FileTouch is a command line utility that allows you to change them. It is similar in functionality to the well-known UNIX touch command.
 
FileTruncate FileTruncate can delete contents of existing files without deleting the actual files. It can even truncate file open in other applications.
 
RunOne RunOne provides methods for limiting an application to a single instance. Just use RunOne my_application.exe my parameters to run your application and it will ensure that only once instance of the application is run at a time. If another instance is already running RunOne simply aborts without starting a new instance. If you want to kill the previous instance you may want to use the KillProcess utility. In addition, RunOne can be used to run applications in hidden or minimized windows.
 
KillProcess KillProcess can be used to quickly close or terminate single or multiple running processes.
 
RunAs RunAs is a command line utility that can be used to run a program under different user account. It is similar to the Windows 2000/XP/2003/Vista native RunAs utility, but it has some distinct features making it more usable then the native version. For example, it accepts password as a command line parameter so that it can be used in batch files; it can also bind started process to the interactive user Desktop so it can be used to start interactive processes from various services such as 24x7 Scheduler, 24x7 Event Server and other.
 
Logon Use Logon utility to schedule Desktop unlocks on Windows NT/2000/XP/2003/Vista systems. This utility should be run when the system is locked and before running other processes requiring simulated user input (using SendKeys or 24x7 MacroRecorder scripts).
 
FileBinReplace FileBinReplace allows multi-file search and replace operations in binary files. FileBinReplace is very fast and can process multiple files described by a file mask. Just as other utilities, it can be run both from the DOS command line and from batch files.
 
RReboot Restart computers remotely. This utility can be used on Windows NT/2000/XP/2003/Vista systems only.
 
Wait Use Wait utility to make your batch files wait.
 

Additional job templates

*** How to add new job template ***
File replication over dynamic dial-up connection
Real-time file and directory mirroring between 2 computers
Bi-weekly schedule
Monthly schedule type -- starting job on nth business day of every month (counting forward from the start of month)
Monthly schedule type -- starting job on nth business day of every month (counting backward from the end of month)
Import data from tab-separated file into database table
Export data from database table into tab-separated file
One-way database replication (replication between same or different kind of database systems)
Two-way database replication (replication between same or different kind of database systems)
Multi-file search & replace operations
File contents watch, find changes and email them
Run program or OS command as another user  -  ** requires v3.2.0 or later
Run job as another user (job can be of any type, including JAL, SQL, and VBScript)  -  ** requires v3.2.0 or later
Copy job to remote 24x7 Schedulers  -  ** requires v3.2.0 or later
Copy entire job folder to remote 24x7 Schedulers  -  ** requires v3.2.0 or later
Copy entire job database including settings to remote 24x7 Schedulers  -  ** requires v3.2.0 or later
Multiple file server free space monitor  -  ** requires v3.2.2 or later

General scripts and tips

Running job between 9:00 AM and 5:00 PM every workday (for 24x7 Scheduler versions 1.0 - 3.1)
Scheduling job to not to run on particular days (job exception days)
Converting dates to file names
Converting comma-separated data file to tab-separated file (24x7 Scheduler versions v1.0 - 1.6.3)
Scanning program log file for errors (24x7 Scheduler versions v1.0 - 1.6.3)
Processing files using file mask
Collecting Web server performance statistics
Monitoring file server free space
Establishing Dial-Up connection, avoiding line drops
Loading data into database
Starting NT service, executing job, stopping service
Paging/notifying system administrators (24x7 Scheduler versions v1.0 - 2.4)
Restoring network connection
Unattended server reboot
Using FTP commands
Redirecting program output to a file
Automating data input for DOS console programs
Verifying overnight data feed
Using Windows messages
Watching for file changes
Adding job error messages to the Windows NT event log
Executing jobs during user "idle" times (24x7 Scheduler versions v1.0 - 1.5.1)
Watching for files (true file watch)
Sending keystroke to a DOS application
Scheduling job to run every 48 hours
Examples of formatting data
Monitoring Windows NT/2000 services
Preventing jobs from the same "class" to run simultaneously (24x7 Scheduler versions v2.0 and later)
Schedule DTS package
Schedule 24x7 Scheduler restart

Advanced scripts and tips

Using 24x7 RA servers for Unix to automate Unix jobs - step-by-step guide with schreenshots (PDF file ~570K)
Using 24x7 API (application program interface)
Using email messages to dynamically create new jobs
Dynamically creating new and modifying existing jobs from a script
Creating restartable jobs (continue after point-of-failure)
Creating "retry on fail" jobs (self-rescheduling jobs) (24x7 Scheduler versions v1.0.0 - v1.6.3)
Using DDE with Lotus Notes to send email
Using DDE with cc:Mail to send email
Using SENDMAIL utility with 24x7 Scheduler
Redirecting standard I/O of a console application using batch file
Calling a program in AS400
Calling a program in AS400 (yet another tip)
Monitoring Oracle database server free space
Automating SQL-Server DBA functions (update statistics)
Automating SQL-Server DBA functions (monitor locks)
Automating SQL-Server DBA functions (monitor and dump filled logs)

Other scripts and tips

Setting connection to Remote Agent (example)
Setting Remote Control connection (example)
Setting Windows NT to automatically logon to the machine and network, bypassing the Winlogon dialog box
Considerations for running 24x7 Scheduler as a service on Windows NT/2000 servers and workstations
Configuring Master and Standby schedulers for fail-over mode (example for 24x7 Scheduler for Windows)
Ensuring High Availability and Fail-over for 24x7 Scheduler Java Edition
Archiving job execution logs
Configuring database interfaces and profiles in 24x7 Scheduler Java Edition

If you have some good scripts or tips that you would like to share please submit them for adding to this archive.


Copyright (c) 2007 SoftTree Technologies, Inc.