Can AWS services replace SQL Server Agent Jobs?
-1
votes
1
answer
271
views
I've decided that I no longer want to use SQL Server Agent Jobs. They're tightly coupled to SQL Server, cause interesting security/permissions problems, and can be complicated to sequence. I instead want to replace them with AWS services, under the assumption that they will be easier to move to Postgres should I ever switch away from SQL Server.
I currently use SQL Server Agent Jobs for the following tasks. Can they be done with AWS Services?
- Running T-SQL code at regular intervals without any care for what it returns, e.g. updating a particular table once an hour.
- Running T-SQL code at regular intervals and using its results to update CloudWatch metrics.
- Running T-SQL code at regular intervals, exporting the result to CSV, then saving that CSV in an S3 bucket.
- Running SQL Server Maintenance Plans.
- Firing SSIS packages.
Asked by J. Mini
(1235 rep)
May 4, 2024, 03:49 PM
Last activity: May 6, 2024, 03:52 PM
Last activity: May 6, 2024, 03:52 PM