Shulou(Shulou.com)05/31 Report--

This article is about how to create regular homework in SQL Server, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

1. First, we open the SQL Server agent and select the job.

2. Right-click the job and select New Job.

3. Fill in some corresponding contents, names and instructions by yourself.

It should be noted that this check box is enabled and should be checked. The category can be changed by default here and can be changed according to your needs.

4. Select the steps and click New.

5. Fill in the step name and the database you are running

* it is important to note that the command line is to execute your stored procedure and write exec directly. . Can

Click on the analysis to find such a frame.

6. Click on the plan to edit the number of times you want to execute the interval.

7. Click OK and the assignment we just created will be displayed.

8. Check whether the execution is correct, and start the email selection job.

9. Ok completed

The above is how to create scheduled jobs in SQL Server. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.