Bulk Enable/Disable Automation for Jira Rules from the Database
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
When importing automation rules in bulk, all rules are initially set to a disabled state. To enable all automation rules at once, this can be accomplished through the database.
This article aims to guide Jira administrators in performing bulk actions on configured automation rules. Through the use of database queries, Jira administrators can effectively activate or deactivate these bulk automation rules.
Environment
Jira Data Center
Solution
This was written and tested using a PostgreSQL DB, so you may need to tweak it depending on the database you are using.
To enable/disable the automation rules from the database, you can update their state in the AO_589059_RULE_CONFIG table. Please perform the below steps:
- Stop the Jira application
Take the backup of the AO_589059_RULE_CONFIG table before making any changes.
To Enable all configured rules in the Jira in bulk, please execute the database query provided below.
update "AO_589059_RULE_CONFIG" set "STATE"='ENABLED';To bulk Disable all the configured rules in Jira, please execute the following database query.
update "AO_589059_RULE_CONFIG" set "STATE"='DISABLED';Start the Jira application and review the status of automation rules.