Teratrax Job Scheduler

Teratrax Job Scheduler has been discontinued. Please refer to the following help file (v1.02) for details on using an existing copy of this product:

 

Help File

Teratrax Job Scheduler allows you to schedule SQL batches and statements for a number of SQL Server instances. Creating scheduled jobs which do no need any human monitoring will help minimize any human error, increase resource efficiency, and lower maintenance cost.

Supported Database Servers

SQL Server 2005
SQL Server 2005 Express
SQL Server 2000
MSDE 2000
SQL Server 7.0
MSDE 1.0

Supported Operating Systems

Windows Server 2003
Windows XP
Windows 2000

.NET Framework 2.0

Getting Started with Teratrax Job Scheduler

Teratrax Job Scheduler consists of two components: Job Agent and Job Scheduler.

  • Teratrax Job Scheduler is the user interface where servers are registered and associated jobs created. The simple interface allows for a quick and easy management of scheduled jobs on multiple SQL Server instances, all managed from a single point.Teratrax Job Scheduler is not required to be open for the scheduled jobs to run. The jobs will automatically run as long as the computer (on which jobs are created) is turned on.
  • Teratrax Job Agent is a Windows service which checks for any scheduled jobs every 10 minutes. On a completion of a scheduled job, whether it is successful or not, Job Agent sends an e-mail notification (Provided the job is configured for notification).

Installation

The install program in Teratrax Job Scheduler guides you through the installation in simple and easy steps. It installs both Job Agent and Job Scheduler. You can only install one copy of Teratrax Job Scheduler on each computer.

User Interface

Teratrax Job Scheduler user interface contains two main panes: A server list located in the left-hand-side and a job list located in the right-hand-side of the main window. The job list shows all associated jobs that have been scheduled to execute for the selected server. Details such as Last Run Time, Last Run Status, and Job Duration are displayed in the list for a quick job status. Teratrax Job Scheduler is not required to be open for the scheduled jobs to run. The jobs will automatically run as long as the computer (on which jobs are created) is turned on.

Registering SQL Server Instances in Job Scheduler

Prior to scheduling any jobs, you must first register the SQL Server instance you wish to run jobs against. From the file menu, click on Add Server Registration and enter the following values in the Server Registration dialog then click Ok:

  1. SQL Server: Name or IP of the SQL Server you want to schedule jobs for (For example, ServerName or ServerName\<instance name> for named instances).
  2. Windows Authentication or SQL Server Authentication: Select the method of authentication for connecting to SQL Server. If Windows Authentication is used, Teratrax Job Agent will use the LocalSystem Windows account to connect to SQL Server and execute jobs. Remote SQL Servers require SQL Authentication.
  3. Login Name: Enter the login name for SQL Server Authentication.
  4. Password: Enter the password for SQL Server Authentication.

Note: Ensure the user account used has the proper permissions to run the T-SQL statements on the specified server.

Scheduling SQL Jobs

The Job Details dialog contains specific information about the scheduled. Job Agent uses this information to run the job against the selected server instance. The SQL script box supports batch processes utilizing the GO command. Furthermore, job names are unique to each server and should therefore be named accordingly. Users can schedule a job to run at the specified time daily, weekly, or monthly.

To schedule a job to run at midnight (12:00 AM), select 00 hours and 00 minutes.

Scheduling a Job

To schedule a job, right click on the job list and select New. Alternatively you can select New from the Job menu.

Enter the following information in the Job Details dialog and click Ok:

  • Job: Enter job name and SQL code in the box under Job Name. Job name cannot exceed 255 characters and cannot contain any special characters {” # ‘ * / : ; < > ? \ |}. The SQL code box supports SQL batches separated by the GO command (GO must be on a separate line).
  • Schedule: Select the specific schedule of the job execution time.

Daily: Executes the job on a daily basis at the specified time.

Weekly: Executes the job once a week at the scheduled time. M to S are the days of the week.

Monthly: Executes the job once a month on the specified day of the month at the specified time.

Scheduling Database Backup Jobs

Scheduling a database backup is a simple two-step process in Teratrax Job Scheduler. You can schedule a database backup through a simple interface which will generate the necessary backup script.

Scheduling Database Backup

Select the information required for scheduling a database backup and click OK to generate the necessary script to be used in scheduling the backup:

  • Database: Select the database you wish to schedule a backup for.
  • Backup File: Enter the path and file name or click on the browse button (…) to select a physical file for your backup.
  • Do not overwrite backup file: Checking this option appends execution date and time stamp to the end of the file dynamically. This option allows you to create backups with unique file names for tracking backup history. If you do not check this box, the backup file will be overwritten every time the job runs.

Click Ok to bring up the Job Details dialog with the properly formatted SQL script text. You will need to set the schedule for the job and click Ok to finish creating the backup job.

Remote SQL Server Backups

You can schedule a local backup on the same computer where Teratrax Job Scheduler is installed, or a remote backup on a remote SQL Server instance. In both cases, the path and name of the backup file are relative to the server. If you are connecting to the local server, the backup file will be created on the computer you are working on. If you are connecting to a remote server, the backup file will be created on the remote server (for example, C:\MyBackups\DB1.bkp would be created on the C:\ drive of the remote server).

To perform a backup from one computer and leave the backup file on another computer, you need to use mapped network drives. For example, if you want to perform a backup of a database on computer A and leave the backup file on computer B, then computer A has to be able to access computer B’s hard drive via a mapped network drive (for example, X:\).

The account used by the SQL Server service must have read/write access to the mapped drive (X:\). By default, SQL Server uses the LocalSystem account to run its service. LocalSystem does not have read/write access to mapped drives. You can change the Windows account used by SQL Server from the Windows Service Manager.

Email Notification for SQL Server Jobs

Teratrax Job Scheduler features the ability to notify a specific contact with the results of scheduled jobs once they are executed by Job Agent. You can enable/disable notification for every job created. Also, you can specify to receive notification on failure or successful completion.

E-mail notification can be disabled for all jobs from the E-mail Notification Configuration dialog. When it is disabled, no e-mail notifications are sent even if the job is configured for notification.

Teratrax Job Scheduler uses SMTP (Simple Mail Transport Protocol) for sending e-mail. You can configure Job Scheduler to use your SMTP server of choice.

E-mail Notification Configuration

You need to configure your mail server before you can receive e-mail notification. Only outgoing mail requires configuration. Teratrax Job Agent will use this configuration to send out e-mail messages once the jobs run.

To configure e-mail notification, Select Tools -> E-mail Notification from Teratrax Job Scheduler:

Disable all e-mail notification: When checked, all e-mail notification will be disabled until this option is unchecked. This option provides an easy way to temporarily disable notification without changing each job’s notification configuration.

SMTP Server: Name of the outgoing SMTP server to use when sending e-mail notifications.

Port: Port number for outgoing e-mail.

User Name: User name used to connect to the mail server.

Password: Password used to connect to the mail server.

Confirm Password: Used to confirm password.

This server requires an encrypted connection (SSL): Check this box if your mail server requires an SSL connection.

Send Test E-mail: Use this button to test e-mail configuration. An e-mail will be send to the e-mail address specified in the “To” box.

From: Indicates the e-mail address used to send e-mail notification.

To: Indicates the e-mail address used to send e-mail notification to.

Cc: If you wish to send a copy of the notification to another e-mail enter the e-mail address here.

Options

The Options dialog in Teratrax Job Scheduler allows you to configure the SQL command timeout for running jobs and the Job Agent auto-start settings.

SQL Command Timeout

  • Timeout for jobs running in the background: Indicates the number of minutes the job can take before it times out. This setting does not affect the timeout for running jobs interactively from the user interface with the Run Job Now feature. Change the default value if you expect the job to take longer than 30 minutes to run. Valid range for this box is 1 to 1440 minutes (1 day).
  • Timeout for jobs running interactively (Run Job Now): Indicates the number of seconds the job can take before it times out when it is started using the Run Job Now feature. This setting does not affect the timeout for jobs that are running on a schedule. Valid range for this box is 1 to 3600 seconds (1 hour).

Job Agent Configuration

The Auto-start Job Agent when Windows starts check box allows you to stop Job Agent from starting automatically when the computer is restarted. Keep this box checked to ensure the execution of scheduled jobs after a computer restart.

Teratrax Job Agent

Teratrax Job Agent is a Windows service that runs in the background and execute jobs. There is no specific configuration required in order for the Job Agent to operate. Instead it utilizes the information obtained from the Server Registration dialog in Teratrax Job Scheduler.

If Windows Authentication is selected for a specific server, Job Agent will use the LocalSystem account to connect to SQL Server.