I have created an automation rule to notify me when any ticket in a given project is in a particular status for 2 weeks.
The automation is currently set to:
When:
Status Changed
If:
Issue matches status = "On Hold"
Issue matches "Project name" = given project
Issue matches timeestimate >= 14d
Then:
Alert user x (where "x" is my email address which is a Jira admin user)
This same rule was previously based on an SLA but that did not work either.