I wrote the script of Oracle scheduled task before. At that time, the script was added to the task plan for the Windows server server, but I encountered that the script could not be added to the task plan in practice (I tried all kinds of methods but could not be added). This is what I thought. Can I write a scheduled task to call the script? Yes, indeed. Source address GitHub

Updated at 21:51 on June 2, 2019 (the time of scheduled task is dynamically adjusted. The previous scheduled task is written on the annotation, which is newly modified to call the fields in h2 table)

Add @ enableshcheduling annotation to spring boot main program

Define components using @ Component

Use @ Scheduled to define Scheduled tasks in the component

JavaRunBatApplication.java

package cn.geoary;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.scheduling.annotation.EnableScheduling;

@SpringBootApplication
@EnableScheduling
public class JavaRunBatApplication {
    public static void main(String[] args) {
        SpringApplication.run(JavaRunBatApplication.class, args);
    }
}

JavaRunBat.java

package cn.geoary.util;

import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * @program: java-run-bat
 * @description: Java Execute bat files regularly
 * @author: geoary
 * @create: 2019-05-06 14:41
 **/
@Component
public class JavaRunBat {
    private static final SimpleDateFormat dateFormat = new SimpleDateFormat("HH:mm:ss");
    /**
     * @description Create scheduled task
     * @param
     * @return
     * @author geoary
     * @date 2019/5/6 
     */
    // Execute at 1:00 every day
    @Scheduled(cron = "0 0 1 * * ?")
    // Once every 3 minutes
    //@Scheduled(cron = "0 0/3 * * * ?")
    public void timingBat(){
        runBat();
    }
    /**
     * @description Execute bat file 
     * @param  
     * @return  
     * @author geoary
     * @date 2019/5/6 
     */
    public static void runBat(){
        String batPath = "E:/backup/data/autobackup.bat";
        execBat(batPath);
        //execBat("1", batPath);
    }
    /**
     * @description Execute bat 
     * @param
     * @return  
     * @author geoary
     * @date 2019/5/6 
     */
    public static void execBat(String ways, String batPath){
        String cmdPre;
        switch (ways){
            case "1":
                // Yes, close the command window after executing the dir command
                cmdPre =  "cmd /c ";
                break;
            case "2":
                // Is not to close the command window after executing the dir command
                cmdPre = "cmd /k ";
                break;
            case "3":
                // A new window will be opened and the dir instruction will be executed, and the original window will be closed
                cmdPre = "cmd /c start ";
                break;
            default:
                // A new window will be opened and the dir instruction will be executed. The original window will not be closed
                cmdPre = "cmd /k start ";
        }
        String cmd = cmdPre + batPath;
        try{
            Process ps = Runtime.getRuntime().exec(cmd);
            InputStream in = ps.getInputStream();
            int c;
            while ((c = in.read()) !=  -1){

            }
            in.close();
            try {
                ps.waitFor();
            }catch (Exception e){
                e.printStackTrace();
            }
            System.out.println("Execution complete"+dateFormat.format(new Date()));
        }catch (Exception e){
            e.printStackTrace();
        }
    }

    public static void execBat(String batPath){
        try{
            Process ps = Runtime.getRuntime().exec("cmd /c start "+ batPath);
            InputStream in = ps.getInputStream();
            int c;
            while ((c = in.read()) !=  -1){
            }
            in.close();
            try {
                ps.waitFor();
            }catch (Exception e){
                e.printStackTrace();
            }
            System.out.println("Execution complete"+dateFormat.format(new Date()));
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}

Scheduled task cron expression:

The general expression is as follows:

Execute @ scheduled at 1 a.m. every day (cron = "0 0 1 * *?")

Execute @ scheduled every 3 minutes (cron = "0 0 / 3 * *?")

So how on earth did this come out?

Official api

In fact, the cron expression is usually followed by 6 characters separated by spaces, and each field identifies a meaning:
second minuters hours dayOfMonth month dayOfWeek

Example: