No Such Plugin error when running SQL job type
search cancel

No Such Plugin error when running SQL job type

book

Article ID: 407783

calendar_today

Updated On:

Products

Autosys Workload Automation

Issue/Introduction

After installing the MS SQL Server plugin on a new agent, when trying to run a job, it is failing with a "No such plugin" error.

Job definition:
insert_job: TECH_TEST_SQL_CMD_RHWVSQL753C   job_type: SQL 
machine: localhost
owner: user@domain
permission: 
date_conditions: 0
description: "test sql command"
alarm_if_fail: 1
alarm_if_terminated: 1
sql_command: "SELECT count(*) FROM ujo_job"

Error:
08/19/2025 10:44:37.202-0400 3 TCP/IP Controller Plugin.Transmitter pool thread <Regular:2>.CybObjectQueue.get[:241] - get  20250819 10443717+0400 DEV_SCH . 12316.25344_1/WAAE_WF0.1/MAIN STATE SUBERROR Failed SetEnd Status(No such plugin)

Resolution

The incorrect plugin was installed.

  • The SQL Server plugin provides support for SQLAGENT job type.
  • The Database plugin provides support for DBMON, DBPROC, DBTRIG and SQL job types. 

Please follow the documented steps to Install WA Agent for Databases.

After plugin install completes, a restart of the agent; not a server reboot, is required for the plugin to be enabled.

After you've completed the installation/configuration, run a test job.