This statement is used to display the running status of the JOB job
SHOW JOBS|JOB FOR job_name;
SHOW JOBS is used to display the running status of all jobs under the current DB, and SHOW JOB FOR job_name is used to display the running status of the specified job.
Db: database name
Name: Job name
Definer: create user
TimeZone: time zone
ExecuteType: RECURRING means cyclic scheduling, that is, the scheduling time specified by the every statement, ONCE_TIME means a one-time task.
ExecuteAT: ONCE_TIME The execution start time of the task
ExecuteInterval: Interval of periodic scheduling tasks
ExecuteInterval: The time interval unit for periodic scheduling tasks
STARTS: The start time of periodic scheduled task settings
ENDS: The end time set by the periodic scheduling task
Status: Job status
LastExecuteFinishTime: The time when the last execution was completed
ErrorMsg: error message
There are the following 5 states:
* RUNNING: running
* PAUSED: Paused
* STOPPED: end (manually triggered by the user)
* FINISHED: Finished
Display all JOBs under the current DB.
Display the JOB named test1
SHOW JOB FOR test1;