AutoSys Workload Automation

Expand all | Collapse all

Autosys: Agent error: No such plugin (SQL)

Jump to Best Answer
  • 1.  Autosys: Agent error: No such plugin (SQL)

    Posted 07-11-2018 05:18 AM

    Hi.

    I have installed SQL plugin and restarted the agent:

     

    cybAgent -v

     

    CA Workload Automation Agent for:
    Windows 64-bit
    11.4, Service Pack 00, Maintenance Level 0, Build 1609

    Enabled plug-in(s):
    - runner
    - router
    - filemon
    - objmon
    - filebrowser
    - ftp
    - sql

     

    SQL plugin is there.

    But whenever I run SQL related job on the server, Agent returns an error: No Such Plugin.

     

    What did I wrong?



  • 2.  Re: Autosys: Agent error: No such plugin (SQL)
    Best Answer

    Posted 07-11-2018 05:45 AM

    SQL job type requires Database agent plugin (CA WA Agent for Databases). You probably have the CA WA Agent for MS SQL SERVER installed.



  • 3.  Re: Autosys: Agent error: No such plugin (SQL)

    Broadcom Employee
    Posted 07-11-2018 05:54 AM

    Hello,

     

    You will need to install the "WA Agent for Databases" to run the "SQL" Job types:

     

    CA Workload Automation Agent for Databases - CA Workload Automation Agent for Databases - 11.3 - CA Technologies Documen… 

     

    After the installation the result of cybAgent -vv will show

     

    cybAgent -v

     

    CA Workload Automation Agent for:
    Windows 64-bit
    11.4, Service Pack 00, Maintenance Level 0, Build 1609

    Enabled plug-in(s):
    - runner
    - router
    - filemon
    - objmon
    - filebrowser
    - ftp
    - sql

    -database < ======

     

    Hope this can help.

     

    Thanks,

    Roya



  • 4.  Re: Autosys: Agent error: No such plugin (SQL)

    Posted 07-11-2018 05:56 AM

    Thank you - it works now