SQL Server on Amazon RDS currently supports SQL Server Agent on the Web, Enterprise and Standard editions. Thus, for situations where there is the need for the agent, clients are presented with the option of upgrading to a more pricier edition of the database to maintain parity with the existing installation or reworking their database tier logic to handle it. However, it is possible rewrite SQL Server Agent job as a Serverless function and this is what Agent-X attempts to show.
- Serverless
- Node 6.0 +
- An existing Slack Webhook Integration
- IAM permissions to allow for the creation of the pertinent AWS resources needed for this project.
- Update the
development.serverless.variables.json
file with the relevant AWS resource IDs and the Slack Webhook URL - Commands:
- Install dependencies:
npm install
- Deployment:
sls deploy --variables development.serverless.variables.json
- Removal:
sls remove --variables development.serverless.variables.json
- Install dependencies:
Note: When removing a deployment of Agent-X in an existing custom VPC using the sls remove
command, it sometimes hangs - refer to: serverless/serverless#5252 .The workaround is for the user to log into the AWS Console to manually detach and delete the Elastic Network Interface associated with the deployed lambda
Out-of-the-box support for Slack integration provides for error reporting in cases of errors with RDS instances, databases, or executed queries.