Amazon RDS Custom SQL-Server: Agent not running

0

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

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.

asked 4 months ago25 views
1 Answer
0
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.

answered 4 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions