Can SQL scripts be executed using Database agent plugin

Article Id: 107136

Status: Published

Updated On: 19-07-2018 10:29

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.