hackergin commented on code in PR #24821:
URL: https://github.com/apache/flink/pull/24821#discussion_r1611267560


##########
flink-table/flink-sql-gateway/src/main/java/org/apache/flink/table/gateway/rest/SqlGatewayRestEndpoint.java:
##########
@@ -181,11 +193,57 @@ private void addStatementRelatedHandlers(
                                 service, responseHeaders, 
FetchResultsHeaders.getInstanceV1())));
     }
 
+    private void addInMemorySchedulerRelatedHandlers(

Review Comment:
   Change `InMemory` to `Embedded`?



##########
flink-table/flink-sql-gateway/src/main/java/org/apache/flink/table/gateway/rest/util/SqlGatewayRestAPIVersion.java:
##########
@@ -48,7 +48,9 @@ public enum SqlGatewayRestAPIVersion
 
     // V2 adds support for configuring Session and allows to serialize the 
RowData with PLAIN_TEXT
     // or JSON format.
-    V2(true, true);
+    V2(false, true),
+
+    V3(true, true);

Review Comment:
   Please add some comments to explain some modifications in V3.



##########
flink-table/flink-sql-gateway/src/main/java/org/apache/flink/table/gateway/workflow/scheduler/EmbeddedQuartzScheduler.java:
##########
@@ -0,0 +1,228 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.flink.table.gateway.workflow.scheduler;
+
+import org.apache.flink.annotation.Internal;
+import org.apache.flink.table.gateway.SqlGateway;
+import org.apache.flink.table.gateway.workflow.WorkflowInfo;
+
+import org.quartz.CronTrigger;
+import org.quartz.Job;
+import org.quartz.JobBuilder;
+import org.quartz.JobDataMap;
+import org.quartz.JobDetail;
+import org.quartz.JobExecutionContext;
+import org.quartz.JobExecutionException;
+import org.quartz.JobKey;
+import org.quartz.Scheduler;
+import org.quartz.TriggerKey;
+import org.quartz.impl.StdSchedulerFactory;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import java.util.Properties;
+import java.util.concurrent.locks.ReadWriteLock;
+import java.util.concurrent.locks.ReentrantReadWriteLock;
+
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.WORKFLOW_INFO;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.fromJson;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.getJobKey;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.initializeQuartzSchedulerConfig;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.toJson;
+import static org.quartz.CronScheduleBuilder.cronSchedule;
+import static org.quartz.TriggerBuilder.newTrigger;
+
+/**
+ * An embedded in-memory workflow scheduler based on quartz {@link Scheduler} 
that store all
+ * workflow in memory, it does not have high availability. This service will 
be embedded in {@link
+ * SqlGateway} process to provide service by rest api.
+ *
+ * <p>This embedded scheduler is mainly used for testing scenarios and is not 
suitable for
+ * production environment.
+ */
+@Internal
+public class EmbeddedQuartzScheduler {
+
+    private static final Logger LOG = 
LoggerFactory.getLogger(EmbeddedQuartzScheduler.class);
+
+    private final ReadWriteLock lock = new ReentrantReadWriteLock();
+
+    private Scheduler quartzScheduler;
+
+    public void start() {
+        Properties properties = initializeQuartzSchedulerConfig();
+        try {
+            quartzScheduler = new 
StdSchedulerFactory(properties).getScheduler();
+            quartzScheduler.start();

Review Comment:
   Here we can add a log statement to indicate that the scheduler has started 
successfully.



##########
flink-table/flink-sql-gateway/src/main/java/org/apache/flink/table/gateway/workflow/scheduler/EmbeddedQuartzScheduler.java:
##########
@@ -0,0 +1,228 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.flink.table.gateway.workflow.scheduler;
+
+import org.apache.flink.annotation.Internal;
+import org.apache.flink.table.gateway.SqlGateway;
+import org.apache.flink.table.gateway.workflow.WorkflowInfo;
+
+import org.quartz.CronTrigger;
+import org.quartz.Job;
+import org.quartz.JobBuilder;
+import org.quartz.JobDataMap;
+import org.quartz.JobDetail;
+import org.quartz.JobExecutionContext;
+import org.quartz.JobExecutionException;
+import org.quartz.JobKey;
+import org.quartz.Scheduler;
+import org.quartz.TriggerKey;
+import org.quartz.impl.StdSchedulerFactory;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import java.util.Properties;
+import java.util.concurrent.locks.ReadWriteLock;
+import java.util.concurrent.locks.ReentrantReadWriteLock;
+
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.WORKFLOW_INFO;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.fromJson;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.getJobKey;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.initializeQuartzSchedulerConfig;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.toJson;
+import static org.quartz.CronScheduleBuilder.cronSchedule;
+import static org.quartz.TriggerBuilder.newTrigger;
+
+/**
+ * An embedded in-memory workflow scheduler based on quartz {@link Scheduler} 
that store all
+ * workflow in memory, it does not have high availability. This service will 
be embedded in {@link
+ * SqlGateway} process to provide service by rest api.
+ *
+ * <p>This embedded scheduler is mainly used for testing scenarios and is not 
suitable for
+ * production environment.
+ */
+@Internal
+public class EmbeddedQuartzScheduler {
+
+    private static final Logger LOG = 
LoggerFactory.getLogger(EmbeddedQuartzScheduler.class);
+
+    private final ReadWriteLock lock = new ReentrantReadWriteLock();
+
+    private Scheduler quartzScheduler;
+
+    public void start() {
+        Properties properties = initializeQuartzSchedulerConfig();
+        try {
+            quartzScheduler = new 
StdSchedulerFactory(properties).getScheduler();
+            quartzScheduler.start();
+        } catch (org.quartz.SchedulerException e) {
+            String msg =
+                    String.format("Failed to start quartz scheduler with 
config: %s.", properties);
+            LOG.error(msg);
+            throw new SchedulerException(msg, e);
+        }
+    }
+
+    public void stop() {
+        try {
+            quartzScheduler.shutdown();
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error("Failed to shutdown quartz schedule.");
+            throw new SchedulerException("Failed to shutdown quartz 
scheduler.", e);
+        }
+    }
+
+    public JobDetail createScheduleWorkflow(WorkflowInfo workflowInfo, String 
cronExpression)
+            throws SchedulerException {
+        String materializedTableIdentifier = 
workflowInfo.getMaterializedTableIdentifier();
+        JobKey jobKey = getJobKey(materializedTableIdentifier);
+
+        lock.writeLock().lock();
+        try {
+            // check if the quartz schedule job is exists firstly.
+            if (quartzScheduler.checkExists(jobKey)) {
+                LOG.error(
+                        "Materialized table {} quartz schedule job already 
exist, job info: {}.",
+                        materializedTableIdentifier,
+                        jobKey);
+                throw new SchedulerException(
+                        String.format(
+                                "Materialized table %s quartz schedule job 
already exist, job info: %s.",
+                                materializedTableIdentifier, jobKey));
+            }
+
+            JobDetail jobDetail =
+                    
JobBuilder.newJob(EmbeddedSchedulerJob.class).withIdentity(jobKey).build();
+            // put workflow info to job data map
+            jobDetail.getJobDataMap().put(WORKFLOW_INFO, toJson(workflowInfo));
+
+            TriggerKey triggerKey = TriggerKey.triggerKey(jobKey.getName(), 
jobKey.getGroup());
+            CronTrigger cronTrigger =
+                    newTrigger()
+                            .withIdentity(triggerKey)
+                            .withSchedule(
+                                    cronSchedule(cronExpression)
+                                            
.withMisfireHandlingInstructionIgnoreMisfires())
+                            .forJob(jobDetail)
+                            .build();
+
+            // Create job in quartz scheduler with cron trigger
+            quartzScheduler.scheduleJob(jobDetail, cronTrigger);
+            LOG.info(
+                    "Create quartz schedule job for materialized table {} 
successfully, job info: {}, cron expression: {}.",
+                    materializedTableIdentifier,
+                    jobKey,
+                    cronExpression);
+
+            return jobDetail;
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error(
+                    "Failed to create quartz schedule job for materialized 
table {}.",
+                    materializedTableIdentifier,
+                    e);
+            throw new SchedulerException(
+                    String.format(
+                            "Failed to create quartz schedule job for 
materialized table %s.",
+                            materializedTableIdentifier),
+                    e);
+        } finally {
+            lock.writeLock().unlock();
+        }
+    }
+
+    public void suspendScheduleWorkflow(String workflowName, String 
workflowGroup)
+            throws SchedulerException {
+        JobKey jobKey = JobKey.jobKey(workflowName, workflowGroup);
+        lock.writeLock().lock();
+        try {
+            if (!quartzScheduler.checkExists(jobKey)) {
+                LOG.error("Failed to suspend a non-existent quartz schedule 
job: {}.", jobKey);
+                throw new SchedulerException(
+                        String.format(
+                                "Failed to suspend a non-existent quartz 
schedule job: %s.",
+                                jobKey));
+            }
+
+            quartzScheduler.pauseJob(jobKey);
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error("Failed to suspend quartz schedule job: {}.", jobKey, e);
+            throw new SchedulerException(
+                    String.format("Failed to suspend quartz schedule job: 
%s.", jobKey), e);
+        } finally {
+            lock.writeLock().unlock();
+        }
+    }
+
+    public void resumeScheduleWorkflow(String workflowName, String 
workflowGroup)
+            throws SchedulerException {
+        JobKey jobKey = JobKey.jobKey(workflowName, workflowGroup);
+        lock.writeLock().lock();
+        try {
+            if (!quartzScheduler.checkExists(jobKey)) {
+                LOG.error("Failed to resume a non-existent quartz schedule 
job: {}.", jobKey);
+                throw new SchedulerException(
+                        String.format(
+                                "Failed to resume a non-existent quartz 
schedule job: %s.",
+                                jobKey));
+            }
+
+            quartzScheduler.resumeJob(jobKey);
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error("Failed to resume quartz schedule job: {}.", jobKey, e);
+            throw new SchedulerException(
+                    String.format("Failed to resume quartz schedule job: %s.", 
jobKey), e);
+        } finally {
+            lock.writeLock().unlock();
+        }
+    }
+
+    public void deleteScheduleWorkflow(String workflowName, String 
workflowGroup)
+            throws SchedulerException {
+        JobKey jobKey = JobKey.jobKey(workflowName, workflowGroup);
+        lock.writeLock().lock();
+        try {
+            if (!quartzScheduler.checkExists(jobKey)) {
+                LOG.error("Failed to delete a non-existent quartz schedule 
job: {}.", jobKey);
+                throw new SchedulerException(
+                        String.format(
+                                "Failed to delete a non-existent quartz 
schedule job: %s.",
+                                jobKey));
+            }
+            quartzScheduler.deleteJob(jobKey);
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error("Failed to delete quartz schedule job: {}.", jobKey, e);
+            throw new SchedulerException(
+                    String.format("Failed to delete quartz schedule job: %s.", 
jobKey), e);
+        } finally {
+            lock.writeLock().unlock();
+        }
+    }
+
+    /** The {@link Job} implementation for embedded quartz scheduler. */
+    private class EmbeddedSchedulerJob implements Job {

Review Comment:
   This class can be changed to static.



##########
flink-table/flink-sql-gateway/src/main/java/org/apache/flink/table/gateway/workflow/scheduler/QuartzSchedulerUtils.java:
##########
@@ -0,0 +1,125 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.flink.table.gateway.workflow.scheduler;
+
+import org.apache.flink.util.jackson.JacksonMapperFactory;
+
+import 
org.apache.flink.shaded.jackson2.com.fasterxml.jackson.databind.ObjectMapper;
+
+import org.quartz.JobKey;
+
+import java.io.IOException;
+import java.io.UncheckedIOException;
+import java.time.Instant;
+import java.time.LocalDateTime;
+import java.time.ZoneId;
+import java.time.format.DateTimeFormatter;
+import java.util.Date;
+import java.util.Properties;
+
+import static org.quartz.impl.StdSchedulerFactory.PROP_SCHED_INSTANCE_NAME;
+import static org.quartz.impl.StdSchedulerFactory.PROP_SCHED_RMI_EXPORT;
+import static org.quartz.impl.StdSchedulerFactory.PROP_SCHED_RMI_PROXY;
+import static org.quartz.impl.StdSchedulerFactory.PROP_THREAD_POOL_CLASS;
+import static org.quartz.impl.StdSchedulerFactory.PROP_THREAD_POOL_PREFIX;
+
+/** Utility class for quartz scheduler. */
+public class QuartzSchedulerUtils {
+
+    public static final String SCHEDULE_TIME_FORMAT = "yyyy-MM-dd HH:mm:ss";
+    public static final DateTimeFormatter DEFAULT_DATETIME_FORMATTER =
+            DateTimeFormatter.ofPattern(SCHEDULE_TIME_FORMAT);
+
+    public static final String QUARTZ_JOB_PREFIX = "quartz_job";
+    public static final String QUARTZ_JOB_GROUP = "default_group";
+    public static final String UNDERLINE = "_";
+    public static final String WORKFLOW_INFO = "workflowInfo";
+
+    private static final ObjectMapper OBJECT_MAPPER = 
JacksonMapperFactory.createObjectMapper();
+
+    /**
+     * This method is used to initializing the scheduler config, the related 
options copy from
+     * quartz.properties file, but we override the option {@code 
org.quartz.threadPool.threadCount}
+     * to 1 for minimizing the thread impact to SqlGateway.
+     */
+    public static Properties initializeQuartzSchedulerConfig() {
+        Properties properties = new Properties();
+        properties.setProperty(PROP_SCHED_INSTANCE_NAME, 
"FlinkQuartzScheduler");
+        properties.setProperty(PROP_THREAD_POOL_PREFIX, 
"FlinkQuartzSchedulerThreadPool");
+        properties.setProperty(PROP_SCHED_RMI_EXPORT, "false");
+        properties.setProperty(PROP_SCHED_RMI_PROXY, "false");
+        properties.setProperty(PROP_THREAD_POOL_CLASS, 
"org.quartz.simpl.SimpleThreadPool");
+        properties.setProperty("org.quartz.threadPool.threadCount", "1");
+        properties.setProperty("org.quartz.threadPool.threadPriority", "5");
+        properties.setProperty(
+                
"org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread",
+                "true");
+        properties.setProperty(
+                
"org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread",
+                "true");
+        properties.setProperty("org.quartz.jobStore.misfireThreshold", 
"60000");
+        properties.setProperty("org.quartz.jobStore.class", 
"org.quartz.simpl.RAMJobStore");
+
+        return properties;
+    }
+
+    public static JobKey getJobKey(String materializedTableIdentifier) {
+        String jobName = QUARTZ_JOB_PREFIX + UNDERLINE + 
materializedTableIdentifier;
+        return JobKey.jobKey(jobName, QUARTZ_JOB_GROUP);
+    }
+
+    public static <T> T fromJson(String json, Class<T> clazz) {
+        try {
+            return OBJECT_MAPPER.readValue(json, clazz);
+        } catch (IOException e) {
+            throw new UncheckedIOException(
+                    String.format(
+                            "Failed to deserialize JSON string to %s: %s.",
+                            clazz.getSimpleName(), e.getMessage()),
+                    e);
+        }
+    }
+
+    public static <T> String toJson(T t) {
+        try {
+            return OBJECT_MAPPER.writeValueAsString(t);
+        } catch (IOException e) {
+            throw new UncheckedIOException(
+                    String.format(
+                            "Failed to serialize instance of %s to JSON 
string: %s.",
+                            t.getClass().getSimpleName(), e.getMessage()),
+                    e);
+        }
+    }
+
+    public static String dateToString(Date date) {

Review Comment:
   Can this method be moved to DateTimeTestUtil since it is only used for 
testing?



##########
flink-table/flink-sql-gateway/src/main/java/org/apache/flink/table/gateway/workflow/scheduler/EmbeddedQuartzScheduler.java:
##########
@@ -0,0 +1,228 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.flink.table.gateway.workflow.scheduler;
+
+import org.apache.flink.annotation.Internal;
+import org.apache.flink.table.gateway.SqlGateway;
+import org.apache.flink.table.gateway.workflow.WorkflowInfo;
+
+import org.quartz.CronTrigger;
+import org.quartz.Job;
+import org.quartz.JobBuilder;
+import org.quartz.JobDataMap;
+import org.quartz.JobDetail;
+import org.quartz.JobExecutionContext;
+import org.quartz.JobExecutionException;
+import org.quartz.JobKey;
+import org.quartz.Scheduler;
+import org.quartz.TriggerKey;
+import org.quartz.impl.StdSchedulerFactory;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import java.util.Properties;
+import java.util.concurrent.locks.ReadWriteLock;
+import java.util.concurrent.locks.ReentrantReadWriteLock;
+
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.WORKFLOW_INFO;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.fromJson;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.getJobKey;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.initializeQuartzSchedulerConfig;
+import static 
org.apache.flink.table.gateway.workflow.scheduler.QuartzSchedulerUtils.toJson;
+import static org.quartz.CronScheduleBuilder.cronSchedule;
+import static org.quartz.TriggerBuilder.newTrigger;
+
+/**
+ * An embedded in-memory workflow scheduler based on quartz {@link Scheduler} 
that store all
+ * workflow in memory, it does not have high availability. This service will 
be embedded in {@link
+ * SqlGateway} process to provide service by rest api.
+ *
+ * <p>This embedded scheduler is mainly used for testing scenarios and is not 
suitable for
+ * production environment.
+ */
+@Internal
+public class EmbeddedQuartzScheduler {
+
+    private static final Logger LOG = 
LoggerFactory.getLogger(EmbeddedQuartzScheduler.class);
+
+    private final ReadWriteLock lock = new ReentrantReadWriteLock();
+
+    private Scheduler quartzScheduler;
+
+    public void start() {
+        Properties properties = initializeQuartzSchedulerConfig();
+        try {
+            quartzScheduler = new 
StdSchedulerFactory(properties).getScheduler();
+            quartzScheduler.start();
+        } catch (org.quartz.SchedulerException e) {
+            String msg =
+                    String.format("Failed to start quartz scheduler with 
config: %s.", properties);
+            LOG.error(msg);
+            throw new SchedulerException(msg, e);
+        }
+    }
+
+    public void stop() {
+        try {
+            quartzScheduler.shutdown();
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error("Failed to shutdown quartz schedule.");
+            throw new SchedulerException("Failed to shutdown quartz 
scheduler.", e);
+        }
+    }
+
+    public JobDetail createScheduleWorkflow(WorkflowInfo workflowInfo, String 
cronExpression)
+            throws SchedulerException {
+        String materializedTableIdentifier = 
workflowInfo.getMaterializedTableIdentifier();
+        JobKey jobKey = getJobKey(materializedTableIdentifier);
+
+        lock.writeLock().lock();
+        try {
+            // check if the quartz schedule job is exists firstly.
+            if (quartzScheduler.checkExists(jobKey)) {
+                LOG.error(
+                        "Materialized table {} quartz schedule job already 
exist, job info: {}.",
+                        materializedTableIdentifier,
+                        jobKey);
+                throw new SchedulerException(
+                        String.format(
+                                "Materialized table %s quartz schedule job 
already exist, job info: %s.",
+                                materializedTableIdentifier, jobKey));
+            }
+
+            JobDetail jobDetail =
+                    
JobBuilder.newJob(EmbeddedSchedulerJob.class).withIdentity(jobKey).build();
+            // put workflow info to job data map
+            jobDetail.getJobDataMap().put(WORKFLOW_INFO, toJson(workflowInfo));
+
+            TriggerKey triggerKey = TriggerKey.triggerKey(jobKey.getName(), 
jobKey.getGroup());
+            CronTrigger cronTrigger =
+                    newTrigger()
+                            .withIdentity(triggerKey)
+                            .withSchedule(
+                                    cronSchedule(cronExpression)
+                                            
.withMisfireHandlingInstructionIgnoreMisfires())
+                            .forJob(jobDetail)
+                            .build();
+
+            // Create job in quartz scheduler with cron trigger
+            quartzScheduler.scheduleJob(jobDetail, cronTrigger);
+            LOG.info(
+                    "Create quartz schedule job for materialized table {} 
successfully, job info: {}, cron expression: {}.",
+                    materializedTableIdentifier,
+                    jobKey,
+                    cronExpression);
+
+            return jobDetail;
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error(
+                    "Failed to create quartz schedule job for materialized 
table {}.",
+                    materializedTableIdentifier,
+                    e);
+            throw new SchedulerException(
+                    String.format(
+                            "Failed to create quartz schedule job for 
materialized table %s.",
+                            materializedTableIdentifier),
+                    e);
+        } finally {
+            lock.writeLock().unlock();
+        }
+    }
+
+    public void suspendScheduleWorkflow(String workflowName, String 
workflowGroup)
+            throws SchedulerException {
+        JobKey jobKey = JobKey.jobKey(workflowName, workflowGroup);
+        lock.writeLock().lock();
+        try {
+            if (!quartzScheduler.checkExists(jobKey)) {
+                LOG.error("Failed to suspend a non-existent quartz schedule 
job: {}.", jobKey);
+                throw new SchedulerException(
+                        String.format(
+                                "Failed to suspend a non-existent quartz 
schedule job: %s.",
+                                jobKey));
+            }
+
+            quartzScheduler.pauseJob(jobKey);
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error("Failed to suspend quartz schedule job: {}.", jobKey, e);
+            throw new SchedulerException(
+                    String.format("Failed to suspend quartz schedule job: 
%s.", jobKey), e);
+        } finally {
+            lock.writeLock().unlock();
+        }
+    }
+
+    public void resumeScheduleWorkflow(String workflowName, String 
workflowGroup)
+            throws SchedulerException {
+        JobKey jobKey = JobKey.jobKey(workflowName, workflowGroup);
+        lock.writeLock().lock();
+        try {
+            if (!quartzScheduler.checkExists(jobKey)) {
+                LOG.error("Failed to resume a non-existent quartz schedule 
job: {}.", jobKey);
+                throw new SchedulerException(
+                        String.format(
+                                "Failed to resume a non-existent quartz 
schedule job: %s.",
+                                jobKey));
+            }
+
+            quartzScheduler.resumeJob(jobKey);
+        } catch (org.quartz.SchedulerException e) {
+            LOG.error("Failed to resume quartz schedule job: {}.", jobKey, e);
+            throw new SchedulerException(
+                    String.format("Failed to resume quartz schedule job: %s.", 
jobKey), e);
+        } finally {
+            lock.writeLock().unlock();
+        }
+    }
+
+    public void deleteScheduleWorkflow(String workflowName, String 
workflowGroup)
+            throws SchedulerException {
+        JobKey jobKey = JobKey.jobKey(workflowName, workflowGroup);
+        lock.writeLock().lock();
+        try {
+            if (!quartzScheduler.checkExists(jobKey)) {

Review Comment:
   There are multiple repetitions of quartzScheduler.checkExists, can it be put 
into a separate method for judgment?



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to