Automic Workload Automation

  • Private Community
Back to discussions
Expand all | Collapse all

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

peter_grundler_automic

peter_grundler_automicNov 22, 2016 06:08 PMBest Answer

Hi Marshall, use sqlcmd or sqlplus as an "external interpreter"
VidyaPraveenBatchu605049

VidyaPraveenBatchu605049Nov 22, 2016 10:44 PM

you may also use OSQL utility

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

    Posted Nov 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 Nov 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 Nov 22, 2016 10:44 PM
    you may also use OSQL utility