Automic Workload Automation

Expand all | Collapse all

Has anyone tried to (or know of any support to) run a .sql file within AE somewhere?

Jump to Best Answer

peter_grundler_automic11-22-2016 06:08 PMBest Answer

VidyaPraveenBatchu60504911-22-2016 10:44 PM

  • 1.  Has anyone tried to (or know of any support to) run a .sql file within AE somewhere?

    Posted 11-22-2016 11:23 AM
    There is a project to automate Data Retention within our databases, and they want to know if we're able to execute a .sql script file within the AE somehow. I know there are ways around this (such as saving the contents into a variable and passing directly to a SQL job), but I wanted to know if there was any native support.


  • 2.  Has anyone tried to (or know of any support to) run a .sql file within AE somewhere?
    Best Answer

    Posted 11-22-2016 06:08 PM

    Hi Marshall,

    use sqlcmd or sqlplus as an "external interpreter"



  • 3.  Has anyone tried to (or know of any support to) run a .sql file within AE somewhere?

    Posted 11-22-2016 10:44 PM
    you may also use OSQL utility