Version |
Description |
update command(s) |
1.5.x |
Add "priority" column to the "qrtz_fired_triggers" table. This example update SQL is for Oracle. Make sure you use the appropriate data type for your database, which can be found in the tables_xxx.sql file for your db. You should leave the value of this new column NULL for existing rows. |
alter table qrtz_fired_triggers add PRIORITY NUMBER(13) |
1.5.x |
Add "priority" column to the "qrtz_triggers" table. This example update SQL is for Oracle. Make sure you use the appropriate data type for your database, which can be found in the tables_xxx.sql file for your db. You should leave the value of this new column NULL for existing rows. |
alter table qrtz_triggers add PRIORITY NUMBER(13) |
1.5.x |
Migrate existing trigger entries to have default priority. |
update qrtz_triggers set PRIORITY = 5 where PRIORITY IS NULL
update qrtz_fired_triggers set PRIORITY = 5 where PRIORITY IS NULL |