Disclaimer: This article may contain information about third-party products. Such information is for reference only. Alibaba Cloud does not make any guarantee, express or implied, with respect to the performance and reliability of third-party products, as well as potential impacts of operations on the products.

Introduction

This article describes how to add a job schedule to an RDS SQL Server instance.

Background

Alibaba Cloud reminds you that:

  • Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
  • You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
  • If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.

When using RDS SQL Server, you can use the client to connect to an instance to add a job schedule. For more information, see the following procedure.

  1. Use a client to connect to an instance.
  2. Click SQL Server agent > Job, right-select Create job.
  3. On the create job page, select general, enter a job name, and click OK.
  4. Selection steps> Create, and on the create job Page, configure the job, and then click OK.
  5. Select plan> Create. On the create job schedule page, configure the job schedule and click OK.
  6. Which notification and target two options, if there is no special requirement, in accordance with the default settings.
  7. Click determined.

Documentation

Application scope

  • ApsaraDB RDS for SQL Server