{"id":13637,"date":"2020-03-16T17:17:18","date_gmt":"2020-03-16T16:17:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/"},"modified":"2020-03-16T17:17:18","modified_gmt":"2020-03-16T16:17:18","slug":"aws-automation-stop-a-rds-instance","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/","title":{"rendered":"AWS Automation &#8211; Stop a RDS instance"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also because on RDS instances are automatically activated when its schedule maintenance is triggered.<\/p>\n<p>In this article I will share the solution I implemented to achieve my goal.<br \/>\nI assume you have already created a RDS instance.<\/p>\n<p>I also mentioned that during the walkthrough even some parameters are optional like name and description, I recommend to set it for a better clarity of your environment.<\/p>\n<p>So first login to your AWS console and let you walkthrough<\/p>\n<h2>1- Preparation of your RDS Instance<\/h2>\n<p>Open the RDS service console and select your RDS instance<br \/>\nAdding tags on the RDS instance is the first step of the process, it will be used later<br \/>\nClick Add and key in a Tag Key and a Tag Value<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png\" alt=\"\" width=\"300\" height=\"105\" class=\"alignnone size-medium wp-image-38236\" \/><\/a><\/p>\n<h2>2- Create a policy<\/h2>\n<p>Now open the IAM service, select the Policies section and create a new policy<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog03_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog03_20200314.png\" alt=\"\" width=\"300\" height=\"210\" class=\"alignnone size-medium wp-image-38237\" \/><\/a><\/p>\n<p>Select the RDS service, typing RDS in the search textbox and selecting RDS in the result list<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog04_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog04_20200314.png\" alt=\"\" width=\"300\" height=\"140\" class=\"alignnone size-medium wp-image-38238\" \/><\/a><br \/>\nThen choose the action by typing StopDBInstance in the search textbox and select the it in the result list.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog05_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog05_20200314.png\" alt=\"\" width=\"300\" height=\"159\" class=\"alignnone size-medium wp-image-38239\" \/><\/a><\/p>\n<p>Type now DescribeDBInstance in the search textbox and select it in the result list<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog06_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog06_20200314.png\" alt=\"\" width=\"300\" height=\"164\" class=\"alignnone size-medium wp-image-38240\" \/><\/a><\/p>\n<p>Check if you have both actions DescribeDBInstance and StopDBInstance listed and select All resources in the Resources part. You can also select specific DB instances if you will.<br \/>\nThan click Review Policy button<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog07_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog07_20200314.png\" alt=\"\" width=\"300\" height=\"212\" class=\"alignnone size-medium wp-image-38241\" \/><\/a><\/p>\n<p>Key in a name for your policy and a description (optional) and click Create Policy<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog08_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog08_20200314.png\" alt=\"\" width=\"300\" height=\"213\" class=\"alignnone size-medium wp-image-38242\" \/><\/a><\/p>\n<p>So we are done with the security policy creation, we can proceed with the next step<\/p>\n<h2>3- Create a role<\/h2>\n<p>Now we have to create a role that will be granted with the policy we just created. The role will be use by System Manager to execute the needed task.<\/p>\n<p>Again in the IAM service console, chose the Role option and create a new role.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog09_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog09_20200314.png\" alt=\"\" width=\"300\" height=\"177\" class=\"alignnone size-medium wp-image-38243\" \/><\/a><\/p>\n<p>Select AWS service in the type of trusted entity and select EC2 in the Use Case list<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog10_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog10_20200314.png\" alt=\"\" width=\"300\" height=\"288\" class=\"alignnone size-medium wp-image-38244\" \/><\/a><\/p>\n<p>In the Select your use case chose EC2 again and click on Next:Permissions button<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog11_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog11_20200314.png\" alt=\"\" width=\"300\" height=\"215\" class=\"alignnone size-medium wp-image-38245\" \/><\/a><\/p>\n<p>In the search text box type AmazonSSMMaintenanceWindowRole and select it in the list<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog12_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog12_20200314.png\" alt=\"\" width=\"300\" height=\"98\" class=\"alignnone size-medium wp-image-38246\" \/><\/a><\/p>\n<p>Repeat permission selection selecting the security policy you created (in my case secpol_RDS_StopDBInstance) and click Next:Tags and Next:Review on the following screen<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog13_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog13_20200314.png\" alt=\"\" width=\"273\" height=\"300\" class=\"alignnone size-medium wp-image-38247\" \/><\/a><\/p>\n<p>Enter a role name and a description (optional), check the policies and click Create Role<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog14_20200314.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog14_20200314.png\" alt=\"\" width=\"275\" height=\"300\" class=\"alignnone size-medium wp-image-38248\" \/><\/a><\/p>\n<p>On the Role screen, notice the information that your role has been created and make sure to see it in the list.<br \/>\nYou can also notice that the Trusted entities for your role is EC2<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog15_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog15_20200315.png\" alt=\"\" width=\"300\" height=\"94\" class=\"alignnone size-medium wp-image-38249\" \/><\/a><\/p>\n<p>As we want to use the role in SSM we have to change the Trusted entity accordingly.<br \/>\nTo achieve that, click on the role you just created, select the Trust relationships tab and click and Edit trust relationship.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog16_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog16_20200315.png\" alt=\"\" width=\"300\" height=\"164\" class=\"alignnone size-medium wp-image-38250\" \/><\/a><\/p>\n<p>You can see that the service is ec2.amazomaws.com.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog17_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog17_20200315.png\" alt=\"\" width=\"300\" height=\"171\" class=\"alignnone size-medium wp-image-38251\" \/><\/a><br \/>\nChange the service replacing ec2 with SSM and click on Update Trust Policy<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog18_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog18_20200315.png\" alt=\"\" width=\"300\" height=\"159\" class=\"alignnone size-medium wp-image-38252\" \/><\/a><\/p>\n<p>We are done concerning the IAM service<\/p>\n<h2>4- Create a resource group<\/h2>\n<p>Now switch to the System Manager service<br \/>\nClick on the menu Services, type System Manager in the search textbox and select System Manager<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog19_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog19_20200315.png\" alt=\"\" width=\"300\" height=\"81\" class=\"alignnone size-medium wp-image-38254\" \/><\/a><\/p>\n<p>Select Resource Groups in the left pane and click on Create resource Group button.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog20_20200315-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog20_20200315-1.png\" alt=\"\" width=\"300\" height=\"106\" class=\"alignnone size-medium wp-image-38255\" \/><\/a><\/p>\n<p>Chose the Tag based option, search for DBInstance and select it as resource type, than search for the tag set on your RDS instance (in my case tag_RDSInstance) and its value (in my case RDS_awsvdata. Enter than a name and a description and click on Create group.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog21_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog21_20200315.png\" alt=\"\" width=\"300\" height=\"195\" class=\"alignnone size-medium wp-image-38256\" \/><\/a><\/p>\n<h2>5- Create maintenance windows<\/h2>\n<p>Switch back on the System Manager service home screen and select Maintenance Windows on the left pane and click on the Create maintenance Window button.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog22_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog22_20200315.jpg\" alt=\"\" width=\"1358\" height=\"532\" class=\"alignnone size-full wp-image-38257\" \/><\/a><\/p>\n<p>Capture a name and a description<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog23_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog23_20200315.jpg\" alt=\"\" width=\"833\" height=\"511\" class=\"alignnone size-full wp-image-38258\" \/><\/a><\/p>\n<p>Define your schedule when your maintenance window must run. Do not omit to specify your time zone to avoid your maintenance window to execute at an unexpected time. Click on the Create maintenance window button.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog24_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog24_20200315.jpg\" alt=\"\" width=\"805\" height=\"773\" class=\"alignnone size-full wp-image-38259\" \/><\/a><\/p>\n<p>Check if your maintenance window has been created and it appears in the list. Check has well that the next execution time match the expected schedule.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog25_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog25_20200315.png\" alt=\"\" width=\"300\" height=\"119\" class=\"alignnone size-medium wp-image-38260\" \/><\/a><\/p>\n<p>Select the maintenance window you just created and select target tab and click on Register target button<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog26_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog26_20200315.png\" alt=\"\" width=\"300\" height=\"97\" class=\"alignnone size-medium wp-image-38261\" \/><\/a><\/p>\n<p>In the Register target screen, defined a name a description and defined the target selecting the Choose a resource group option and selecting the resource group created in point 4. Select also your resource types if you have other resources than DBInstance in your resource group. Click register target button.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog27_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog27_20200315.jpg\" alt=\"\" width=\"618\" height=\"788\" class=\"alignnone size-full wp-image-38262\" \/><\/a><\/p>\n<p>Next step is to register an Automation task. Select again your maintenance window and chose the Tasks tab and click on Register task selecting the Register Automation task.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog28_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog28_20200315.png\" alt=\"\" width=\"300\" height=\"119\" class=\"alignnone size-medium wp-image-38263\" \/><\/a><\/p>\n<p>Set a name and a description.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog29_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog29_20200315.jpg\" alt=\"\" width=\"849\" height=\"498\" class=\"alignnone size-full wp-image-38264\" \/><\/a><\/p>\n<p>Select the Automation document, scrolling in the pages to find and select AWS-StopRDSInstance<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog30_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog30_20200315.jpg\" alt=\"\" width=\"672\" height=\"771\" class=\"alignnone size-full wp-image-38265\" \/><\/a><\/p>\n<p>Define the target selecting the registered target group and the one you created previously. Set the rate control according to your need and constrains.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog31_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog31_20200315.jpg\" alt=\"\" width=\"680\" height=\"675\" class=\"alignnone size-full wp-image-38266\" \/><\/a><\/p>\n<p>Then important is to defined the IAM service role selecting the role you created in point 3.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog32_20200315.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog32_20200315.jpg\" alt=\"\" width=\"686\" height=\"303\" class=\"alignnone size-full wp-image-38267\" \/><\/a><br \/>\nIn the input parameter use enter the ID of your RDS database instance.<br \/>\nFinally click the Register Automation task.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog33_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog33_20200315.png\" alt=\"\" width=\"300\" height=\"114\" class=\"alignnone size-medium wp-image-38268\" \/><\/a><\/p>\n<h2>6- Test you Maintenance Window<\/h2>\n<p>If you can stop your instance whenever you want, adjust your Cron settings to a near time and check the history of your maintenance window.<br \/>\nAfter the schedule time check the maintenance window history<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog34_20200315.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog34_20200315.png\" alt=\"\" width=\"300\" height=\"115\" class=\"alignnone size-medium wp-image-38269\" \/><\/a><\/p>\n<h2>Conclusion<\/h2>\n<p>There are indeed some tricks to go through and to know in order to setup this but it is worth doing it to avoid costs surprises.<br \/>\nHoping you enjoy reading<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also because on RDS instances are automatically activated when its schedule maintenance is triggered. In this [&hellip;]<\/p>\n","protected":false},"author":38,"featured_media":13638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,229,198],"tags":[708,133,1869,1870],"type_dbi":[],"class_list":["post-13637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-database-administration-monitoring","category-database-management","tag-automation","tag-aws","tag-rds","tag-stopdbinstance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>AWS Automation - Stop a RDS instance - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWS Automation - Stop a RDS instance\" \/>\n<meta property=\"og:description\" content=\"Introduction I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also because on RDS instances are automatically activated when its schedule maintenance is triggered. In this [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-16T16:17:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1890\" \/>\n\t<meta property=\"og:image:height\" content=\"661\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Christophe Cosme\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christophe Cosme\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/\"},\"author\":{\"name\":\"Christophe Cosme\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"headline\":\"AWS Automation &#8211; Stop a RDS instance\",\"datePublished\":\"2020-03-16T16:17:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/\"},\"wordCount\":967,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png\",\"keywords\":[\"Automation\",\"AWS\",\"RDS\",\"StopDBInstance\"],\"articleSection\":[\"Cloud\",\"Database Administration &amp; Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/\",\"name\":\"AWS Automation - Stop a RDS instance - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png\",\"datePublished\":\"2020-03-16T16:17:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png\",\"width\":1890,\"height\":661},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Automation &#8211; Stop a RDS instance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\",\"name\":\"Christophe Cosme\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"caption\":\"Christophe Cosme\"},\"description\":\"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"AWS Automation - Stop a RDS instance - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/","og_locale":"en_US","og_type":"article","og_title":"AWS Automation - Stop a RDS instance","og_description":"Introduction I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also because on RDS instances are automatically activated when its schedule maintenance is triggered. In this [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/","og_site_name":"dbi Blog","article_published_time":"2020-03-16T16:17:18+00:00","og_image":[{"width":1890,"height":661,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png","type":"image\/png"}],"author":"Christophe Cosme","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christophe Cosme","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/"},"author":{"name":"Christophe Cosme","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"headline":"AWS Automation &#8211; Stop a RDS instance","datePublished":"2020-03-16T16:17:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/"},"wordCount":967,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png","keywords":["Automation","AWS","RDS","StopDBInstance"],"articleSection":["Cloud","Database Administration &amp; Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/","url":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/","name":"AWS Automation - Stop a RDS instance - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png","datePublished":"2020-03-16T16:17:18+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog02_20200314.png","width":1890,"height":661},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/aws-automation-stop-a-rds-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"AWS Automation &#8211; Stop a RDS instance"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a","name":"Christophe Cosme","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","caption":"Christophe Cosme"},"description":"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.","url":"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=13637"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13637\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/13638"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13637"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}