Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The dependencies of the SQL server agent jobs with other platforms or applications can also be managed easily via UAC workflows.

Version Information

Template Name

Extension Name

Extension Version

CS MSSQL-Server-Agent 

ue-cs-mssql-server-agent

1.0.0

Refer to Changelog for version history information.

...

Software Requirements for Universal Template and Universal Task

Requires Python 3.7.6 or higher. Tested with the Universal Agent bundled Python distribution.

...

  • Universal Agent for Windows x64 Version 7.14.0.0 and later with Python options installed.

  • Universal Agent for Linux Version 7.14.0.0 and later with Python options installed.

  • Requires "pymssql" python module to be installed in the Agent host 

  • This integration connects to the MSSQL server via pymssql 

    • Check if the stored procedure "UAC_START_STOP_MSSQL_AGENT_JOB" exists before the SQL server agent job is triggered. If it doesn't exist, then it creates the stored procedure 

...

Universal Controller Version 7.14.0.0 and later.

Network and Connectivity Requirements

...

  1. This Universal Task requires the Resolvable Credentials feature. Check that the Resolvable Credentials Permitted system property has been set to true.

  2. To import the Universal Template into your Controller, follow these instructions.

  3. When the files have been imported successfully, refresh the Universal Templates list; the Universal Template will appear.

...

This document references the following documents.

Document Link

Description

Universal Templates

User documentation for creating, working with, and understanding Universal Templates and Integrations.

Universal Tasks

User documentation for creating Universal Tasks in the Universal Controller user interface.

Credentials

User documentation for creating and working with credentials.

Resolvable Credentials Permitted Property

User documentation for Resolvable Credentials Permitted Property.

...