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 |
| Versions | 9.x, 10.x, 11.x |
| 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.
|
|