System error: "No Database Agent Service running" (4368728)

System error: "No Database Agent Service running"

The Database Agent service manages data processing outside of the SQL services allowing for improved performance over utilizing the SQL Agent and services on the database server.

After setup the following error may appear, "No Database Agent Service Running".

The Database Agent service has not been deployed correctly.

During the Configuration Wizard

With the configuration wizard you may deploy a job server during setup. The Database Agent should be selected by default to be deployed and may be confirmed by the following steps.

1, On the Service installation screen, check off the Advanced option at the bottom.

2. Select Plugins found under Configuration / Module List.

3. 'databaseagentplugin' should be displayed as a selected plugin. If not:

- Click the Insert button.

- Choose the 'DatabaseAgentPlugin'


Add the Database Agent to an Existing Job Server

If an existing Job Server has sufficient processing and memory resources for the Database Agent service, it may be deployed to an existing system.

1. From an Admin Workstation, open Designer and login with a system admin identity.

2. Select 'Add Job server' from the Navigation-Getting Started pane.

3. From the list of Job Servers select an existing job server.

4. Once selected, switch the bottom center pane to the 'Machine role' view.

5. Place a check box next to "Database Agent.'

6. Commit to database.


Deploy to a New Job Server

For larger deployments:

1. From an Admin Workstation, open the Designer application and login with a system admin identity.

2. Select 'Add Job server' from the Navigation-Getting Started pane.

3. Click the Add new Job Server button.

4. Enter the Server name, the remaining fields should auto complete or are not necessary.

5. Switch to the Machine role view and select the Database Agent.

6. Commit to Database.

7. Right-click on the new Job Server and choose Install Service.

- Configure the job service settings to match your environment.

8. Repeat for additional servers for redundancy.

For more information, please refer to the Configuration Guide, Processing DBQueue Processor tasks by the Database Agent Service.