7.2 Configuring the Task Scheduler Service and SQL Server Jobs

The Task Scheduler Configuration Utility allows you to perform most of the tasks related to configuring the Task Scheduler service and SQL Server jobs, including:

  • Adding repositories to and removing them from the service

  • Changing the authentication method the service uses to connect to a repository

  • Changing the schedule for SQL Server jobs

  • Disabling SQL Server jobs

Because the SQL Server jobs handle internal data management, you should not change the default schedule or attempt to modify the SQL Server job steps unless a NetIQ Technical Support representative or implementation consultant instructs you to do so, or unless you fully understand the impact of making a change.

Access the utility from the Start menu.

To add a repository to the service:

  1. In the Tasks pane, click Add.

  2. Provide the required information about the repository.

    If you are using a port other than the default port (1433) for communications with SQL Server, you must use the format SQL_Server_Name/Instance,Port_Number when you specify the SQL Server name.

  3. Click OK.

To remove a repository from the service:

  1. In the Tasks pane, click Remove.

  2. Select the repository you want to remove, and then click OK.

To change the authentication method for a repository:

  1. In the repository grid, select the repository you want to modify.

  2. In the Tasks pane, click Modify.

  3. Provide the required account information, and then click OK.

To change the schedule for a job:

  1. In the repository grid, select the repository that contains the job you want to modify.

  2. In the job grid, select the job you want to modify.

  3. In the Tasks pane, click Change Schedule.

  4. Select the desired schedule settings, and then click OK.

To disable a job:

  1. In the repository grid, select the repository that contains the job you want to disable.

  2. In the job grid, select the job you want to disable.

  3. In the Tasks pane, click Disable.

    To re-enable the job, click Enable.

In slow or busy network environments, you might find that you need to make adjustments to better adapt communication between the repositories and the service to your environment. A standard .NET XML configuration file, NetIQTaskScheduler.exe.config, includes parameters that you can change to address performance and communication issues. The default location for the configuration file is C:\Program Files\NetIQ\AppManager\TaskScheduler\bin.

Before you edit the file, contact Technical Support.

You can edit the following parameters:

CmdTimeout

The time to wait (in seconds) before terminating an attempt to execute a SQL command and generating an error.

The default value is 0 seconds, which means that attempts to execute SQL commands will never time out.

ConnTimeout

The time to wait (in seconds) before terminating an attempt to establish a connection to an instance of SQL Server and generating an error.

The default value is 15 seconds.

SQLJobDiscoveryInterval

The frequency (in minutes) at which the Task Scheduler service checks the repositories to discover new or removed SQL Server jobs and update the Task Scheduler Configuration Utility.

The default value is 30 minutes.