Automic Workload Automation

Hi Team,

I have a SQL Script (Sample.sql) . How to configure and execute it from UC4 ?

UC4 Version: 10.0.2+build.624

JRE Version: 1.7.0_25 64 Bit

Hi.

Pretty much the same way you would do without UC4: You pipe the sql file to your sql command line client. You can, however, do this in an OS job from within UC4, but this mostly makes sense if you have to do this task regularily.

If your SQL is supposed to run against a supported database for the SQL agent, you could also take the contents of the SQL file and paste it into an SQL job, if you had an SQL agent for UC4. However, this also only makes sense for repeat tasks and even then, I'd probably go with the piping to the sql command-line client.

Hth,

Carsten

Hello, try SQL utilities to run the command in OS job from Automation Engine.