MS SQL Uproc Template

This is an uproc template to execute SQL queries in MS SQL from Dollar Universe.


Descriprion

This is an uproc template to execute SQL queries in MS SQL from Dollar Universe.


Uproc description

The Uproc accepts the following variables:



    • SQL_SERVER: This is the name of the SQL Server instance

    • SQL_FILE: This is the SQL file to execute

    • SQL_DATABASE: This is the name of the database to connect to

    • SQL_LOGIN: Username to use to connect to MS SQL

    • SQL_PASSWORD: Password to use to connect to MySQL

    • SQL_LOG: Log to store the output (optional)

    • DISPLAY_JOBLOG: Display the output in the Job Log (Y or N)



This is a Windows uproc.

Prerequisites: MS SQL client installed locally.

Implementation: This has to be imported in Dollar Universe with the "uxins UPR" command.

0
0
Please log in using your Broadcom account to download this plugin.
Please log in using your Broadcom account to download this plugin.
Products Workload Automation, Dollar Universe Workload Automation
Versions 5.x
Operating Systems Windows
Solution Area Data
Last update 2015-09-04 21:08:04.0
Supported by
Community Source ms-sql-uproc-template

Broadcom does not support, maintain or warrant Solutions, Templates, Actions and any other content published on the Community and is subject to Broadcom Community Terms and Conditions.