Can SQL scripts be executed using Database agent plugin
book
Article ID: 107136
calendar_today
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)CA Workload Automation AE - Scheduler (AutoSys)CA Workload Automation Agent
Issue/Introduction
Can I execute a SQL script with the Database agent plugin?
Environment
Release: Component: DBSAGT
Resolution
DB Plugin does not support running SQL scripts. You can run SQL queries. If you are interested in the ability to execute SQL scripts, please review the idea/enhancement request located at https://communities.ca.com/ideas/235730095-database-jobs-to-support-plsql-sql-files and vote the idea up.