Create a SQL job

For tasks that run on a schedule such as a database reindex or statistics update, you can use a SQL Job to execute those tasks.

Tol create a SQL job:

1. Open SQL Server Management Studio.

2. Navigate to SQL Server Agent/Jobs in the navigation panel.

   

3. Right-click on Jobs. The New Job dialog box opens.

   

4. Enter the data in the information panel. Ensure you select the owner of the Telligent Enterprise database from the Owner drop-down list.

5. Select Steps in the navigation panel.

6. Click New. The New Job Step dialog box displays.

    

7. Enter the data in the information panel.

   1. Enter a unique name in the Step name field.

   2. Select your database from the Database drop-down list.

   3. Specify the command you want executed.

   4. Click OK to close the New Job Step dialog box and return to the New Job dialog box.

8. Select Schedules in the navigation panel.

9. Click New. The New Job Schedule dialog box displays.

   

10. Enter your data in the New Job Schedule dialog box.

    1. Enter a unique name in the Name data field.

    2. Specify the day and time you want the job to run. The screen shot example above shows that the job will run on Saturdays at 11:00 P.M.

    3. Click OK to close the New Job Schedule dialog.

11. Click OK again.