Intention/requirement is to run a stored procedure in certain interval. How to configure SQL server agent in Amazon RDS? Is there any alternative for of SQL server agent in RDS which can help us to run procedures like concurrent programs/cron jobs?

Reputation: 351

RDS - SQL server agent

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

How to configure SQL server agent in Amazon RDS?
Is there any alternative for of SQL server agent in RDS which can help us to run procedures like concurrent programs/cron jobs?

Upvotes: 2

Reputation: 29

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.

Upvotes: 2