api jobs - SAP-archive/xsk GitHub Wiki

{
	"description": "My Job configuration",
	"action": "xsjob_demo:handler.xsjslib::writeInDB",
	"schedules": [
		{
			"description": "Execute every 5 seconds",
			"xscron": "* * * * * * */5",
			"parameter": {
			}
		}
	]
}

function writeInDB() {
    var connection;
    try {
        connection = $.db.getConnection();
        
        var insertStatement = connection.prepareStatement("INSERT INTO XSJOB_DEMO (EXECUTED_AT) VALUES (CURRENT_TIMESTAMP)");
        insertStatement.executeUpdate();
        insertStatement.close();
    } catch(e) {
        connection.rollback();
        console.log("Transaction was rolled back: " + e.message);
    } finally {
       connection.close();
    }
}

var job = new $.jobs.Job({ uri: "xsjob_demo/definition.xsjob" });

// execute the job for 60 seconds, starting from now
job.configure({ status: true, start_time: new Date(), end_time: new Date(Date.now() + 60000) });