notice that the maintenance plan is not under SQL Server Agent. Navigate to the maintenance plan, managed by. The maintenance plan is not created by default on the database. Right-click the maintenance plan and you see the new Maintenance Plan and
next step is to create the plan, the operation of creating the plan is very simple, the interface is very detailed, I will not say much. You can also configure alerts and notifications, but this is rarely used. While it's easy to use the SQL job to perform a backup of SQL scripts, but at least it's time to write the backup script, some people feel uncomfortable, is there a simpler, more lazy way to implement automatic scheduled backup of the database
Linux scheduled monitoring and maintenance services
Taking the encryption and decryption service as an example, I provide the encryption and decryption service. Others call my service. Because Linux machines are remote, I don't know where the machines are in a specific environment, I don't know if the machine is restarted. I need to maintain the stability of my services. What should I do?
Two things need to
The open-source Quartz framework dynamically adds, modifies, and deletes scheduled tasks (2). the quartz framework
It seems that every time I look back at some of the previously written items, I don't always feel perfect ~~ Although you are not a perfect person, you have to do the perfect thing! This time, we mainly focused on the Dynamic Maintenance of Quartz an
Method One
SQL Server 2005 's scheduled backup function works well, and daily scheduled backups ensure data security.
The settings for scheduled backups are also simple, and the first step is to enter the Microsoft SQL Server Management studio--> Management--> Maintenance plan to create a new
restarting the app.
First, let's review the configuration code for using quartz in spring:All the configuration is done in XML, including the Cronexpression expression, which is very convenient. But if you have a lot of scheduled tasks and need to change manually, you have to have a whole bunch of XML configurations that are not easy to manage.So at design time I think of the following points1, reduce the spring configuration file.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.