Home > Teratrax Job Scheduler > Help > Registering SQL Server Instances in Job Scheduler

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.