Timer setting method and device, equipment and computer readable storage medium

Abstract

The invention discloses a timer setting method and device, equipment and a computer readable storage medium, and the method comprises the steps: reading an identifier carried by a newly-added timer when the newly-added timer is detected, and determining a target data table corresponding to the newly-added timer according to the identifier; comparing the first time range of the newly added timer with a second time range of a historical timer corresponding to the target data table one by one, and judging whether a target second time range coinciding with the first time range exists in each second time range or not; and if so, determining the overlap ratio between the first time range and the target second time range, and setting a newly added timer according to the size relationship betweenthe overlap ratio and a preset threshold. According to the scheme, the newly added timer is set based on the size relationship between the overlap ratio generated by the big data processing technologyand the preset threshold value; the overlapping of timing time ranges between the newly added timer and the historical timer is avoided, and the normal execution of each timing task is ensured.

Description

technical field [0001] The present invention mainly relates to the technical field of data processing, in particular to a timer setting method, device, equipment and computer-readable storage medium. Background technique [0002] In the process of database management, multiple timers are usually set to trigger certain tasks on the data table; such as setting a certain time to delete invalid data in the data table, or setting a certain time to delete the invalid data in the data table Pulling of pending renewal policies, etc.; triggered by a timer, can avoid manually triggering the execution of tasks, saving labor costs, and improving the efficiency of task execution. [0003] However, there are many timing tasks that need to be executed in the same data table, so that there are many timers set for the same data table; the timing times set between the timers are prone to overlap, resulting in the occurrence of various tasks during the execution process. Chaos, the previous t...

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a timer setting method, device, equipment and computer-readable storage medium, aiming to solve the timing time overlap between the timers in the prior art, which leads to confusion in the execution of each timing task or Issues that could not be processed within the time limit

Images