Analysis and selection of planned task plans

The analysis system only has one scheduled task executed every minute. A task is the only command channel in the execution application program. It reads the activation task records of the database's scheduled task table, if the execution conditions are met, the operation is executed. If the conditions are not met, the operation is skipped. The advantage is that you can flexibly add tasks to... Plan Task Analysis

1. The system has only one scheduled task executed once per minute. A task is the only command channel in the application that reads the activation task records of the database's scheduled task table,
   If the execution conditions are met, the operation is executed. If the conditions are not met, the operation is skipped. The advantage is that you can flexibly add tasks to the database without having to execute each operating system command. The disadvantage is that you can read the database frequently every minute.

2. In an application, the system creates several scheduled tasks. The advantage is that you do not need to execute system commands frequently. The disadvantage is that you need the system administrator privilege to add tasks each time.

So the question is

1. Are you sure you want to add the advantages and disadvantages of the above two solutions?
2. Are there other solutions that you can discuss?
3. You can vote for the option.

Reply content: Plan Task Analysis

1. The system has only one scheduled task executed once per minute. A task is the only command channel in the application that reads the activation task records of the database's scheduled task table,
   If the execution conditions are met, the operation is executed. If the conditions are not met, the operation is skipped. The advantage is that you can flexibly add tasks to the database without having to execute each operating system command. The disadvantage is that you can read the database frequently every minute.

2. In an application, the system creates several scheduled tasks. The advantage is that you do not need to execute system commands frequently. The disadvantage is that you need the system administrator privilege to add tasks each time.

So the question is

1. Are you sure you want to add the advantages and disadvantages of the above two solutions?
2. Are there other solutions that you can discuss?
3. You can vote for the option.

I personally think that the second solution is better than parallel execution, and each scheduled task does not interfere with each other. If the first type is used, when a task is time-consuming, the execution of subsequent tasks may be delayed. If a task encounters a problem, the subsequent tasks may be executed normally.