Scheduled Job - Database
This section shows how to create the database table for the Scheduled Job application.
- Navigate to the
SQL Viewenter the following script:
create table LOG_EVENTS ( LOG_ID integer primary key auto_increment, LOG_SEVERITY varchar(16), LOG_MESSAGE varchar(120), LOG_TIMESTAMP timestamp );
Runicon to execute the SQL script.
Press Ctrl+X for Windows, Cmd+X for macOS to execute the SQL script.
Note: You can execute all or part of the SQL scripts in the
SQL Viewby making a selection and pressing the
Runicon or the keyboard shortcut.
Refreshbutton to see the
- Right click on the
LOG_EVENTStable and select Show Contents.
- The table data would be displayed in the
As the table is empty, there should be no data:
After completing the steps in this tutorial, you would:
- Have database table named
- Be familiar with the
Database Perspective, the
SQL Viewand the
Continue to the Job Handler section to create a
Job Handler, that would be executed by the
Note: The complete content of the Scheduled Job tutorial is available at: https://github.com/dirigiblelabs/tutorial-scheduled-job-project