WO2019205387A1 - Workbook monitoring method and apparatus, computer device, and storage medium - Google Patents

Abstract

Disclosed in the present application are a workbook monitoring method and apparatus, a computer device, and a storage medium. The method comprises: performing real-time monitoring on a workbook according to a monitoring plan, and if there is an email task or an attachment generation task to be completed in a workbook at a current time, executing the email task or the attachment generation task; if the email task is executed, monitoring the execution flow, and recording the flow of executing the email task in a task execution log; if the attachment generation task is executed, monitoring the execution flow, and recording the flow of executing the attachment generation task in the task execution log; and performing parsing according to the task execution log to obtain a task execution report.

Description

Workbook monitoring method, device, computer device and storage medium

The present application claims priority to Chinese Patent Application No. 201810373386.9, filed on April 24, 2018, the entire disclosure of which is incorporated herein by reference. Combined in this application.

Technical field

The present application relates to the technical field of workbooks, and in particular, to a workbook monitoring method, apparatus, computer device and storage medium.

Background technique

In the daily work process, sending an email or inserting an attachment in a mail and sending it can transfer the information conveniently and quickly.

However, the workbook used in the prior art is not monitored, so mail sending or attachment generation cannot be performed by monitoring the workbook. When the mail task or the attachment generating task is abnormal and cannot be successfully processed, in the normal situation The abnormal situation is difficult to be discovered, and it is necessary to find out the error in the mail or the mail task is abnormal after the mail is sent. It takes a certain amount of time to find an abnormal situation and process the abnormal situation. This period wastes the user's time. Therefore, this discovery and processing of the abnormal link reduces the efficiency of mail sending and attachment generation, and the work for the user. Make an impact.

Summary of the invention

The embodiments of the present application provide a method, a device, a computer device, and a storage medium for monitoring a workbook, and aim to solve the problem that the workbook is not monitored in the prior art, and the abnormal situation is not efficiently processed.

In a first aspect, an embodiment of the present application provides a workbook monitoring method, including:

The workbook is monitored in real time according to the monitoring plan. If there is a mail task or an attachment generation task to be completed in the current time workbook, the mail task or the attachment generation task is executed;

If the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log;

If the attachment generation task is executed, the execution process is monitored, and the process of executing the attachment generation task is recorded in the task execution log;

The task execution report is obtained according to the task execution log parsing.

In a second aspect, an embodiment of the present application provides a workbook monitoring apparatus, including:

The real-time monitoring unit is configured to perform real-time monitoring on the workbook according to the monitoring plan. If there is a mail task or an attachment generating task to be completed in the current time workbook, the mail task or the attachment generating task is executed;

The mail task execution unit is configured to: if the mail task is executed, monitor the execution process, and record the process of executing the mail task in the task execution log;

The accessory generation task execution unit is configured to: if the accessory generation task is executed, monitor the execution process, and record the process of the accessory generation task execution in the task execution log;

The processing result parsing unit is configured to obtain a task execution report according to the task execution log parsing.

In a third aspect, the embodiment of the present application further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer The workbook monitoring method described in the above first aspect is implemented at the time of the program.

In a fourth aspect, the embodiment of the present application further provides a storage medium, wherein the storage medium stores a computer program, where the computer program includes program instructions, and the program instructions, when executed by the processor, cause the processor to execute The workbook monitoring method described in the above first aspect.

The embodiment of the present application provides a workbook monitoring method, device, computer device, and storage medium. The method monitors the mail task and the attachment generation task in the workbook by setting a monitoring plan, records the flow of the mail task and the attachment generation task execution, and obtains the task execution report by obtaining the processing result and the information in the task execution log. It is convenient for the user to view the execution of the mail task and the attachment generation task in the workbook through the task execution report, which can greatly improve the processing speed of the abnormal situation and improve the efficiency of mail sending and attachment generation.

DRAWINGS

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings used in the description of the embodiments will be briefly described below. Obviously, the drawings in the following description are some embodiments of the present application, For the ordinary technicians, other drawings can be obtained based on these drawings without any creative work.

FIG. 1 is a schematic flowchart of a workbook monitoring method according to an embodiment of the present application;

2 is a schematic diagram of a sub-flow of a workbook monitoring method according to an embodiment of the present application;

FIG. 3 is another schematic flowchart of a workbook monitoring method according to an embodiment of the present disclosure;

FIG. 4 is another schematic flowchart of a workbook monitoring method according to an embodiment of the present disclosure;

FIG. 5 is another schematic flowchart of a workbook monitoring method according to an embodiment of the present application;

FIG. 6 is a schematic block diagram of a workbook monitoring apparatus according to an embodiment of the present application;

FIG. 7 is a schematic block diagram of a subunit of a workbook monitoring apparatus according to an embodiment of the present application;

FIG. 8 is a schematic block diagram of another subunit of the workbook monitoring apparatus according to an embodiment of the present application;

FIG. 9 is a schematic block diagram of another subunit of the workbook monitoring apparatus according to an embodiment of the present application;

FIG. 10 is another schematic block diagram of a workbook monitoring apparatus according to an embodiment of the present application;

FIG. 11 is a schematic block diagram of a computer device according to an embodiment of the present application.

detailed description

The technical solutions in the embodiments of the present application are clearly and completely described in the following with reference to the drawings in the embodiments of the present application. It is obvious that the described embodiments are a part of the embodiments of the present application, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.

The use of the terms "comprising", "comprising", "","," The presence or addition of a plurality of other features, integers, steps, operations, elements, components, and/or collections thereof.

The terminology used herein is for the purpose of describing particular embodiments and is not intended to be limiting. As used in the specification and the appended claims, the claims

It is further understood that the term "and/or" used in the specification and the appended claims means any combination of one or more of the associated listed items and all possible combinations, and includes the combinations .

Please refer to FIG. 1. FIG. 1 is a schematic flow chart of a workbook monitoring method provided by an embodiment of the present application, which is applied to a terminal computer, a laptop computer, a tablet computer, and the like. As shown in FIG. 1, the method includes steps S101 to S104.

S101: Perform real-time monitoring on the workbook according to the monitoring plan. If there is a mail task or an attachment generating task to be completed in the current time workbook, perform a mail task or an attachment generating task.

The system monitors the mail task and the attachment generation task in the workbook in real time through a preset monitoring plan, where the monitoring plan includes the name of the mail task to be monitored, the ID number of the mail task to be monitored, and the attachment generation task to be monitored. Name, ID number of the task to be monitored, and the interval between monitoring. A workbook is a form that records an employee's daily work plan. The workbook contains the mail tasks and attachment generation tasks that are required to be performed during the employee's daily work.

Among them, the mail task includes the mail task name, the mail task ID number, the mail task creation time, and the mail task update time. When the mail task is created, the task management system automatically generates the mail task creation time and saves it as an unchangeable item. The operator can update the mail task at any time after the mail task is created. When the operator updates the mail task, The mail task is updated, and the task management system records the current time of the mail task update as the mail task update time. When the operator updates the mail task again, the task management system deletes the time information in the old mail task update time and updates it to new. Time information, which is to ensure that the mail task update time is the last time the mail task was updated.

The mail task also includes parameters such as the sender of the mail, the recipient of the mail, the initial sending time of the mail, the current sending time of the mail, and the frequency of sending the mail. The mail can be sent multiple times within the time period after the initial sending time of the mail, and the mail sending frequency can be According to the specific requirements of use, you can set to send once a day, send multiple times a day, send once a week, send multiple times a week, send once a month, or send multiple times a month.

The initial sending time of the mail is the time when the mail is sent for the first time. The user can choose to send the mail only once according to the actual use demand; or according to the initial sending time of the mail and the sending frequency of the mail, after a certain time interval of the initial sending time of the mail, the certain time is The sending frequency is sent multiple times. For example, when the frequency of sending a user's mail is days, the time when the mail is sent for the first time is the initial sending time of the mail, and the time when the mail is sent for the second time is the time interval of the initial sending of the mail, and the time of sending the mail for the Nth time. In order to initially send a time interval of 24 x (N-1) hours with the mail.

The current sending time of the mail is the sending time of the mail to be sent, and the task management system automatically calculates the current sending time of the mail according to the initial sending time of the mail and the frequency of mail sending. If the mail task is updated, the mail sending time and mail sending frequency are calculated, and the current sending time of the mail after the mail task is updated is calculated. When the task management system monitors the current time when the current time is overwritten by the mail, that is, the mail task to be completed in the current time workbook, the mail task is executed.

For example, the content of the mail task is as shown in Table 1.

Table 1

In Table 1, the name of the mail task is mail transmission, and the ID number of the mail task is 2237. The mail task creation date is 2017-9-19, 22:08; the mail task update time is 2017-12-4, 12:00; the mail delivery time in the mail task is 2017-9-20, 9:50; The current sending time is 2017-12-5, 12:00, and the mail sending frequency is day. Since the mail task has been updated, the current sending time of the mail is calculated by the mail task update time and the mail sending frequency. The sender of the email is XXX@xx.com.cn and the recipient of the email is XXXX@xx.com.cn.

The task management system monitors the current time as 2017-12-5, 12:03, and the current time has covered the current sending time of the mail 2017-12-5, 12:00, that is, the mail task to be completed in the current time workbook, then The mail task is executed.

The attachment generation task includes the name of the attachment generation task, the ID number of the attachment generation task, the attachment creation task creation time, the attachment generation task update time, the attachment information acquisition time, and the attachment generation frequency. When the attachment generation task is created, the task management system automatically generates the attachment creation task creation time and saves it as an unchangeable item. The operator can update the attachment generation task at any time after the attachment generation task is created. When the operator updates the attachment generation task, the attachment generation task is updated, and the task management system records the attachment generation task update time as the attachment generation task update. Time, when the operator updates the attachment generation task again, the task management system deletes the time information in the old attachment generation task update time, and updates the attachment generation task update time to the new time information.

The attachment information acquisition time is the generation time of the attachment to be generated, and the task management system generates the task creation time and the attachment generation frequency according to the attachment, and automatically obtains the attachment information acquisition. If the attachment generation task is updated, the task update time and the attachment generation frequency are generated through the attachment, and the attachment information acquisition time after the attachment generation task is updated is calculated.

The content of the attachment generation task is shown in Table 2.

ID_ATTACH_GEN 1309 WORKBOOK_ID 2069 GEN_NAME Attachment generation 1 WORKBOOK_NAME Sample Supermarket - Site Report 7 (Extract Report) GEN_TIME 2018-1-29 15:55 GEN_TYPE 0 FREQUENCY Day STATE 0 CREATED_BY SSSS DATE_CREATED 2018-1-10 15:24 UPDATED_BY SSSS DATE_UPDATED 2018-1-28 15:56

Table 2

In Table 2, the name of the attachment generation task is Annex 1 and the ID of the attachment generation task is 1309. The attachment creation task creation date is 2018-1-10, 15:24; the attachment generation task update time is 2018-1-18, 15:56; the attachment information acquisition time is 2018-1-29, 15:55, attachment generation frequency For the day, since the attachment generation has been updated, the attachment information acquisition time is calculated by the attachment generation task update time and the attachment generation frequency.

For example, the task management system monitors that the current time is 2018-1-29, 16:00, and the current time has covered the attachment information acquisition time 2018-1-29, 15:55, that is, the attachment generation task to be completed in the current time workbook. The task is executed for the attachment generation task.

Real-time monitoring of mail tasks and attachment generation tasks in the workbook through a preset monitoring plan. For example, the interval between monitoring can be set to 20 seconds or 1 minute, and the task management system can be separated by 20 seconds or 1 minute. The interval is used to monitor the mail task and the attachment generation task. The scope of the monitoring includes the mail task name and the mail task in the mail task corresponding to the mail task ID number, and the name of the attachment generation task and the ID number of the attachment generation task. The attachment generation task in the attachment generation task.

Among them, the mail task name or the mail task ID number can be used to find the corresponding mail task, so the mail task name and the mail task ID number need only know one to find the mail task, which is convenient for the user to use, and the task management system monitors If the current time has overwritten the current sending time of the mail, the mail task is executed. The attachment generation task can be searched by the name of the attachment generation task or the ID number of the attachment generation task. Therefore, the attachment generation task name and the attachment generation task ID number need only know one to search for the attachment generation task, which is convenient for the user to use. When the task management system monitors that the current time has covered the attachment information acquisition time, the attachment generation task is executed.

S102. If the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log.

When the mail task begins to execute, the task management system monitors the execution process of the mail task in real time, and records the process of executing the mail task in the task execution log for subsequent analysis of the process performed by the mail task.

In an embodiment, as shown in FIG. 2, step S102 includes sub-steps S1021 and S1022.

S1011: Obtain a mail task delay time during the execution of the mail task, and a mail task takes a long time.

The mail task delay time is the time between the execution time of the mail task and the current sending time of the mail. When the mail task begins to execute, the execution time at which the mail task begins execution is recorded. There is a delay in the process from the trigger to the execution of the mail task, and the interval of monitoring set in the task management system will affect the delay time of the mail task. By recording and analyzing the delay time of the mail task, the user can understand The delay of the task execution of the mail task execution process.

The mail task takes a long time, that is, the elapsed time from the start of the mail task to the completion of the mail task. When the number of files to be sent in the mail task is small, and the system space occupied by the file is small, the mail task takes a relatively long time. Short; when the number of files to be sent in the mail task is large or the system space occupied by the file is large, the mail task takes a long time, and the user can understand the mail by recording and analyzing the elapsed time of the mail task. The length of time spent in task execution.

S1022: Record the mail task delay time and the mail task elapsed time in the task execution log.

The task management system automatically records the delay time of the mail task and the elapsed time of the mail task, and records the delay time of the mail task and the elapsed time of the mail task in the task execution log for subsequent analysis.

In the actual application process, the mail task delay time threshold and the mail task elapsed time threshold may be set in the task management system, and when the mail task delay time exceeds the threshold or the mail task takes longer than the threshold, the execution of the mail task is interrupted, and Get the task execution log. Specifically, the mail task delay time threshold is 1 hour, and the mail task time duration threshold is 2 hours.

S103. If the attachment generation task is executed, the execution process is monitored, and the process of executing the attachment generation task is recorded in the task execution log.

When the attachment generation task starts to be executed, the task management system monitors the execution flow of the attachment generation task in real time, and records the process of executing the attachment generation task in the task execution log for subsequent analysis of the process of the attachment generation task execution.

In an embodiment, as shown in FIG. 3, step S103 includes sub-steps S1031 and S1032.

S1031: Acquire an attachment generation task delay time during the execution of the attachment generation task, and an elapsed time for the attachment generation task.

The attachment generation task delay time is the interval between the execution time at which the attachment generation task starts executing and the attachment information acquisition time. When the attachment generation task starts execution, the execution time at which the attachment generation task starts execution is recorded. There is a certain delay in the process from the trigger to the execution of the attachment generation task, and the interval of the monitoring set in the task management system will affect the delay time of the attachment generation task. By recording and analyzing the delay time of the attachment generation task, Let the user know the delay of the task execution task execution task execution.

The attachment generation task takes a long time, that is, the elapsed time from the start of the attachment generation task to the completion of the attachment generation task. When the number of attachments required to be generated in the attachment generation task is small, and the system space occupied by the attachment is small, the attachment generation is performed. The duration of the task is correspondingly shorter; when the number of attachments to be generated in the attachment generation task is large or the system space occupied by the attachment is large, the attachment generation task takes a long time, and the time required for generating the attachment is recorded. And analysis, which enables users to understand how long it takes to perform an attachment generation task.

S1032: Record the delay time of the attachment generation task and the elapsed time of the attachment generation task in the task execution log.

The task management system automatically records the attachment generation task delay time and the attachment generation task elapsed time, and records the attachment generation task delay time and the attachment generation task elapsed time in the task execution log for subsequent analysis.

In the actual application process, the attachment generation task delay time threshold and the attachment generation task elapsed time threshold may be set in the task management system, and when the attachment generation task delay time exceeds the threshold or the attachment generation task takes longer than the threshold, the attachment generation is interrupted. Execute the task and get the task execution log. Specifically, the attachment generation task delay time threshold may be set to 1 hour, and the attachment generation task consumption duration threshold is 2 hours.

S104. Obtain a task execution report according to task execution log parsing.

Specifically, the task management system obtains the processing result of the mail task and/or the attachment generating task, and obtains the task execution report according to the task execution log parsing, and the user can view the execution of the mail task number and the attachment generating task through the task execution report. The task execution log includes the processing result of the mail task or the attachment generation task.

The task management system obtains the processing result of the mail task, and obtains the task execution report according to the task execution log parsing. The task execution log is parsed to obtain a task execution report. In some cases, although the mail task is successfully executed, the mail task delay time is long or the mail task takes a long time, which makes the mail task execution inefficient and affects the user's work. In this case, the task execution log needs to be performed. Analysis.

For example, although the mail task is executed successfully, the mail task delay time is too long, the user sets the mail sending time to 10:20, and the monitoring time interval set in the task management system is 1 hour. At 10:00, the task management system monitors the mail task once and does not find the mail task that needs to be executed at 10:00. At 11:00, the task management system monitors that a mail task needs to be 10 before 11:00. : 20 for mail sending, the mail task delay time of this mail task is 40 minutes, when the mail task delay time threshold set by the user is 20 minutes, the mail task delay time exceeds the set threshold, and the work for the user When the task management system parses the task execution log, the task execution report includes the delay of the mail task due to the monitoring time, that is, the user can modify the set monitoring according to the content in the task execution report. Intervals. For example, the monitoring interval is set to 15 minutes, that is, every 15 minutes, the task association system monitors the mail task once to meet the actual usage requirements.

The task execution log is parsed to obtain the task execution report. In the case that the mail task execution is unsuccessful, the user can optimize the configuration of the task management system according to the content in the task execution report, and perform the mail task execution again after optimization. .

For example, during the execution of the mail task, the mail task fails to be executed due to the network problem, the attachment upload in the mail fails, and the mail task execution is unsuccessful. The task execution report obtained by the task management system after parsing the task execution log includes If the network fails and the attachment fails to be uploaded, the user can perform related troubleshooting according to the task execution report. At this time, the task management system will perform the mail task again after troubleshooting the network.

The task management system obtains the processing result of the attachment generation task, and obtains the task execution report according to the task execution log parsing.

The task execution log is parsed to obtain a task execution report. In some cases, although the attachment generation task is successfully executed, the attachment generation task has a long delay time or the attachment generation task takes a long time, which makes the attachment task execution efficiency inefficient and affects the user's work. Execute the log for parsing.

For example, although the attachment generation task is executed successfully, the attachment generation task takes too long, and the attachment generated is too large, which requires a long time to generate the attachment, which affects the user's work efficiency. In the specific use process, the task execution report obtained by parsing the task execution log by the task management system includes the attachment generation task having a long time due to the large attachment, because the content of the attachment generated is too much. The user can modify the number of attachments generated in the attachment generation task according to the content in the task execution report to shorten the elapsed time of the attachment generation task, and divide the original larger attachment into multiple parts and generate multiple attachments respectively. It can take a long time to shorten the attachment generation task to meet the actual use requirements.

The task execution log is parsed to obtain the task execution report. In the case that the attachment generation task is unsuccessful, the user can optimize the configuration of the task management system according to the content of the task execution report, and perform the attachment generation task again after optimization. Execution.

In an embodiment, as shown in FIG. 4, step S104 further includes step S1041.

S1041. If the processing result of the mail task or the attachment generation task is that the execution is unsuccessful, try to execute the mail task or the attachment generation task again.

If the processing result of the mail task or the attachment generation task is unsuccessful, the task management system attempts to perform the mail task or the attachment generation task again at the next monitoring according to the monitored interval time.

In an embodiment, as shown in FIG. 5, step S100 is further included before step S101.

S100: Generate a monitoring plan of the workbook, and obtain information about the activation of the monitoring plan.

Before the task management system monitors the workbook, it also needs to generate a monitoring plan for the workbook. After the task management system obtains the activation information of the monitoring plan, the monitoring plan can be enabled. The monitoring plan includes the name of the mail task to be monitored, the ID number of the mail task to be monitored, the name of the attachment generating task to be monitored, the ID number of the attachment generating task to be monitored, and the monitoring interval. After the monitoring plan is enabled, the task management system monitors the monitored mail task and the attachment generation task to be monitored at regular intervals according to the monitoring interval.

In the present application, the mail task and the attachment generation task in the workbook are monitored by setting a monitoring plan, and the flow of the mail task and the attachment generation task execution is recorded, and the task execution is obtained by obtaining the processing result and the information in the task execution log. report. It is convenient for the user to view the execution of the mail task and the attachment generation task in the workbook through the task execution report, which can greatly improve the processing speed of the abnormal situation and improve the efficiency of mail sending and attachment generation.

The embodiment of the present application further provides a workbook monitoring apparatus, which is used to execute any of the foregoing workbook monitoring methods. Specifically, please refer to FIG. 6. FIG. 6 is a schematic block diagram of a workbook monitoring apparatus provided by an embodiment of the present application. The workbook monitoring device 10 can be configured in a desktop computer, a tablet computer, a laptop computer, or the like.

As shown in FIG. 6, the workbook monitoring apparatus 10 includes a real-time monitoring unit 101, a mail task execution unit 102, an attachment generation task execution unit 103, and a processing result analysis unit 104.

The real-time monitoring unit 101 is configured to perform real-time monitoring on the workbook according to the monitoring plan. If there is a mail task or an attachment generating task to be completed in the current time workbook, the mail task or the attachment generating task is executed.

The mail task execution unit 102 is configured to monitor the execution flow when the mail task is executed, and record the flow of the mail task execution in the task execution log.

In other application embodiments, as shown in FIG. 7, the mail task execution unit 102 includes a sub-unit mail task execution flow monitoring unit 1021 and a mail task execution flow recording unit 1022.

The mail task execution process monitoring unit 1021 is configured to obtain a mail task delay time and a mail task elapsed time during the execution of the mail task.

The mail task execution process recording unit 1022 is configured to record the mail task delay time and the mail task elapsed time in the task execution log.

The attachment generation task execution unit 103 is configured to monitor the execution flow when the attachment generation task is executed, and record the execution process of the attachment generation task in the task execution log.

In other application embodiments, as shown in FIG. 8, the attachment generation task execution unit 103 includes sub-units: an attachment task execution flow monitoring unit 1031 and an attachment task execution flow recording unit 1032.

The attachment task execution process monitoring unit 1031 is configured to acquire an attachment generation task delay time and an attachment generation task elapsed time during the execution of the attachment generation task.

The attachment task execution process recording unit 1032 is configured to record the attachment generation task delay time and the attachment generation task elapsed time in the task execution log.

The processing result parsing unit 104 is configured to obtain a task execution report according to the task execution log parsing.

In other application embodiments, as shown in FIG. 9, the processing result parsing unit 104 includes a subunit: the re-execution unit 1041.

The re-execution unit 1041 is configured to attempt to perform the mail task or the attachment generation task again if the processing result of the mail task or the attachment generation task is unsuccessful in execution.

In other application embodiments, as shown in FIG. 10, the workbook monitoring apparatus 10 further includes a monitoring plan generating unit 100.

The monitoring plan generating unit 100 is configured to generate a monitoring plan of the workbook, and obtain the activation information of the monitoring plan.

The above workbook monitoring device can be implemented in the form of a computer program that can be run on a computer device as shown in FIG.

Please refer to FIG. 11. FIG. 11 is a schematic block diagram of a computer device according to an embodiment of the present application. The computer device 500 device can be a terminal. The terminal can be an electronic device such as a tablet computer, a notebook computer, a desktop computer, or a personal digital assistant.

The computer device 500 includes a processor 502, a memory, and a network interface 505 that are coupled by a system bus 501, where the memory can include a non-volatile storage medium 503 and an internal memory 504. The non-volatile storage medium 503 can store an operating system 5031 and a computer program 5032. The computer program 5032 includes program instructions that, when executed, cause the processor 502 to perform a workbook monitoring method. The processor 502 is used to provide computing and control capabilities to support the operation of the entire computer device 500. The internal memory 504 provides an environment for operation of the computer program 5032 in the non-volatile storage medium 503, which when executed by the processor 502, may cause the processor 502 to perform a workbook monitoring method. The network interface 505 is used for network communication, such as sending assigned tasks and the like. It will be understood by those skilled in the art that the structure shown in FIG. 11 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation of the computer device 500 to which the solution of the present application is applied, and a specific computer device. 500 may include more or fewer components than shown, or some components may be combined, or have different component arrangements.

The processor 502 is configured to run a computer program 5032 stored in the memory to implement real-time monitoring of the workbook according to the monitoring plan, and if there is a mail task or an attachment generating task to be completed in the current time workbook, Execute a mail task or an attachment generation task; if the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log; if the attachment generation task is executed, the execution process is monitored, and the attachment generation task is executed. The process is recorded in the task execution log; the task execution report is obtained according to the task execution log parsing.

In an embodiment, the processor 502 further performs the following operations: acquiring a mail task delay time during the execution of the mail task, and a mail task duration; and recording the mail task delay time and the mail task elapsed time in the task execution log.

In an embodiment, the processor 502 further performs the following operations: acquiring the attachment generation task delay time and the attachment generation task elapsed time during the execution of the attachment generation task; and recording the attachment generation task delay time and the attachment generation task elapsed time in the task. Execution log.

In an embodiment, the processor 502 further performs an operation of attempting to perform a mail task or an attachment generation task again if the processing result of the mail task or the attachment generation task is unsuccessful in execution.

In an embodiment, the processor 502 also performs the operations of generating a monitoring plan of the workbook and obtaining activation information of the monitoring plan.

It will be understood by those skilled in the art that the embodiment of the computer device shown in FIG. 11 does not constitute a limitation on the specific configuration of the computer device. In other embodiments, the computer device may include more or fewer components than illustrated. Or combine some parts, or different parts. For example, in some embodiments, the computer device may include only a memory and a processor. In such an embodiment, the structure and function of the memory and the processor are the same as those of the embodiment shown in FIG. 11, and details are not described herein again.

It should be understood that, in the embodiment of the present application, the processor 502 may be a central processing unit (CPU), and the processor 502 may also be another general-purpose processor, a digital signal processor (DSP), Application Specific Integrated Circuit (ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware component, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

In another embodiment of the present application, a storage medium is provided. The storage medium can be a non-transitory computer readable storage medium. The storage medium stores a computer program, wherein the computer program includes program instructions. The workbook monitoring method of the embodiment of the present application is implemented when the program instruction is executed by the processor.

The storage medium may be an internal storage unit of the aforementioned device, such as a hard disk or a memory of the device. The storage medium may also be an external storage device of the device, such as a plug-in hard disk equipped on the device, a smart memory card (SMC), a secure digital (SD) card, and a flash memory card. (Flash Card), etc. Further, the storage medium may also include both an internal storage unit of the device and an external storage device.

A person skilled in the art can clearly understand that for the convenience and brevity of the description, the specific working process of the device, the device and the unit described above can refer to the corresponding process in the foregoing method embodiment, and details are not described herein again.

The foregoing is only a specific embodiment of the present application, but the scope of protection of the present application is not limited thereto, and any equivalents can be easily conceived by those skilled in the art within the technical scope disclosed in the present application. Modifications or substitutions are intended to be included within the scope of the present application. Therefore, the scope of protection of this application should be determined by the scope of protection of the claims.

Claims (20)

A workbook monitoring method, comprising: The workbook is monitored in real time according to the monitoring plan. If there is a mail task or an attachment generation task to be completed in the current time workbook, the mail task or the attachment generation task is executed; If the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log; If the attachment generation task is executed, the execution process is monitored, and the process of executing the attachment generation task is recorded in the task execution log; The task execution report is obtained according to the task execution log parsing. The workbook monitoring method according to claim 1, wherein if the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log, including: Obtain the mail task delay time during the execution of the mail task, and the mail task takes a long time; The mail task delay time and the mail task elapsed time are recorded in the task execution log. The workbook monitoring method according to claim 1, wherein if the attachment generation task is executed, the execution flow is monitored, and the process of executing the attachment generation task is recorded in the task execution log, including: Obtaining the attachment generation task delay time and the attachment generation task elapsed time during the execution of the attachment generation task; The attachment generation task delay time and the attachment generation task elapsed time are recorded in the task execution log. The workbook monitoring method according to claim 1, wherein the task execution log includes a processing result of a mail task or an attachment generating task; After the task execution report is parsed according to the task execution log, the method further includes: If the processing result of the mail task or the attachment generation task is unsuccessful, try to execute the mail task or the attachment generation task again. The workbook monitoring method according to claim 1, wherein the workbook is monitored in real time according to the monitoring plan, and if the mail task or the attachment generating task to be completed in the current time workbook is executed, the mail task or the attachment is executed. Before generating the task, it also includes: Generate a monitoring plan for the workbook and get activation information for the monitoring plan. A workbook monitoring device, comprising: The real-time monitoring unit is configured to perform real-time monitoring on the workbook according to the monitoring plan. If there is a mail task or an attachment generating task to be completed in the current time workbook, the mail task or the attachment generating task is executed; The mail task execution unit is configured to: if the mail task is executed, monitor the execution process, and record the process of executing the mail task in the task execution log; The accessory generation task execution unit is configured to: if the accessory generation task is executed, monitor the execution process, and record the process of the accessory generation task execution in the task execution log; The processing result parsing unit is configured to obtain a task execution report according to the task execution log parsing. The workbook monitoring apparatus according to claim 6, wherein the mail task execution unit comprises: The mail task execution process monitoring unit is configured to obtain a mail task delay time and a mail task elapsed time during the execution of the mail task; The mail task execution process recording unit is configured to record the mail task delay time and the mail task elapsed time in the task execution log. The workbook monitoring apparatus according to claim 6, wherein the accessory generation task execution unit comprises: The accessory task execution process monitoring unit is configured to obtain an attachment generation task delay time and an attachment generation task elapsed time during the execution process of the attachment generation task; The attached task execution process recording unit is configured to record the attachment generation task delay time and the attachment generation task elapsed time in the task execution log. The workbook monitoring apparatus according to claim 6, wherein the processing result analyzing unit comprises: Execute the unit again, if the processing result of the mail task or the attachment generation task is unsuccessful, try to execute the mail task or the attachment generation task again. The workbook monitoring device according to claim 6, further comprising: A monitoring plan generating unit is configured to generate a monitoring plan of the workbook and obtain activation information of the monitoring plan. A computer apparatus comprising a memory, a processor, and a computer program stored on the memory and operative on the processor, wherein the processor, when executing the computer program, implements the following steps: The workbook is monitored in real time according to the monitoring plan. If there is a mail task or an attachment generation task to be completed in the current time workbook, the mail task or the attachment generation task is executed; If the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log; If the attachment generation task is executed, the execution process is monitored, and the process of executing the attachment generation task is recorded in the task execution log; The task execution report is obtained according to the task execution log parsing. The computer device according to claim 11, wherein if the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log, including: Obtain the mail task delay time during the execution of the mail task, and the mail task takes a long time; The mail task delay time and the mail task elapsed time are recorded in the task execution log. The computer device according to claim 11, wherein if the attachment generation task is executed, the execution flow is monitored, and the process of executing the attachment generation task is recorded in the task execution log, including: Obtaining the attachment generation task delay time and the attachment generation task elapsed time during the execution of the attachment generation task; The attachment generation task delay time and the attachment generation task elapsed time are recorded in the task execution log. The computer device according to claim 11, wherein the task execution log includes a processing result of a mail task or an attachment generation task; After the task execution report is parsed according to the task execution log, the method further includes: If the processing result of the mail task or the attachment generation task is unsuccessful, try to execute the mail task or the attachment generation task again. The computer device according to claim 11, wherein the workbook is monitored in real time according to a monitoring plan, and if a mail task or an attachment generating task to be completed in the current time workbook is executed, the mail task or the attachment generating task is executed. Previously, it also included: Generate a monitoring plan for the workbook and get activation information for the monitoring plan. A storage medium, characterized in that the storage medium stores a computer program, the computer program comprising program instructions that, when executed by a processor, cause the processor to perform the following operations: The workbook is monitored in real time according to the monitoring plan. If there is a mail task or attachment generation task to be completed in the current time workbook, the mail task or the attachment generation task is executed; If the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log; If the attachment generation task is executed, the execution process is monitored, and the process of executing the attachment generation task is recorded in the task execution log; The task execution report is obtained according to the task execution log parsing. The storage medium according to claim 16, wherein if the mail task is executed, the execution process is monitored, and the process of executing the mail task is recorded in the task execution log, including: Obtain the mail task delay time during the execution of the mail task, and the mail task takes a long time; The mail task delay time and the mail task elapsed time are recorded in the task execution log. The storage medium according to claim 16, wherein if the attachment generation task is executed, the execution flow is monitored, and the process of executing the attachment generation task is recorded in the task execution log, including: Obtaining the attachment generation task delay time and the attachment generation task elapsed time during the execution of the attachment generation task; The attachment generation task delay time and the attachment generation task elapsed time are recorded in the task execution log. The storage medium according to claim 16, wherein the task execution log includes a processing result of a mail task or an attachment generation task; After the task execution report is parsed according to the task execution log, the method further includes: If the processing result of the mail task or the attachment generation task is unsuccessful, try to execute the mail task or the attachment generation task again. The storage medium according to claim 16, wherein the workbook is monitored in real time according to a monitoring plan, and if a mail task or an attachment generating task to be completed in the current time workbook is executed, the mail task or the attachment generating task is executed. Previously, it also included: Generate a monitoring plan for the workbook and get activation information for the monitoring plan.

Images