Automatically create MS SQL Agent Jobs

Reads SQL Agent Jobs from MS SQL Server and creates Automic Jobs


This Template can be used to create Automic Jobs based on SQL that selects all SQL Agent Jobs in MS SQL Server. The Form Tab is great if you have a few Jobs, but when you try to "convert" 100s of SQL Agent Jobs to Automic Jobs, then this little template can be you friend.

To run it you will need to adjust the Variables in the Workflow to match your enviornment. I also added a Breakpoint after the JOBS.SQL.FIND_JOBS, so you can verify the output and the SQL_DEFINED_JOBS variable.

No content available.
No content available.
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, Automic Automation
Operating Systems Windows
Solution Area Data
Last update 2015-05-16 17:02:22.0
Supported by
Community Source automatically-create-ms-sql-agent-jobs

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.