RDS - SQL server agent

2
votes

Intention/requirement is to run a stored procedure in certain interval.

  1. How to configure SQL server agent in Amazon RDS?
  2. Is there any alternative for of SQL server agent in RDS which can help us to run procedures like concurrent programs/cron jobs?
1
amazon-web-servicesamazon-rds
i don't think any database as service has sql agent.In azure ,you can use azure elastic jobs,not sure rds - TheGameiswar
trying to follow - docs.aws.amazon.com/AmazonRDS/latest/UserGuide/… - Debarshi DasGupta

1 Answers

2
votes

RDS does have the SQL Agent starting at the Web version (it is not enabled at the Express license), and it works well.

One thing to note is that the time schedule always need to be at UTC timezone, it is not possible to change it.