Amazon RDS Custom SQL-Server: Agent not running

Question

Hello,

I am an absolute beginner to Amazon RDS. I've created an RDS Custom Instance for SQL Server Standard. After connecting; I've tried to activate SQL Jobs:

```
 sp_configure 'show advanced options', 1; 
 GO 
 RECONFIGURE; 
 GO 
 sp_configure 'Agent XPs', 1; 
 GO 
 RECONFIGURE 
 GO
```
Now I 'm able to create jobs, but they are not runnable. Error message is:
![Enter image description here](/media/postImages/original/IMq67JX8WBQ6imvShJoGuT-g)

I've found no advanced setting in RDS admin or Management Studio where I am able to activate the agent. According to the documentation, this feature should work:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html

Can anybody point me into the right direction please how to get it running? Thanks in advance.

Accepted Answer

Did a support request, if anyone else stumbles upon this: Use the underlying EC2 instance to start the service. You can open a PowerShell-Session. There you can start services.

Answer

You should change the agent log file path to D drive.

```
-- enable SQL Server Agent
exec sp_CONFIGURE 'show advanced options',1;
GO
RECONFIGURE WITH OVERRIDE;
GO
exec sp_CONFIGURE 'Agent XPs', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO

-- update the SQL Server Agent log file path
USE [msdb] 
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @errorlog_file=N'D:\rdsdbdata\Log\SQLAgent.out';
GO
```

Amazon RDS Custom SQL-Server: Agent not running

相關內容