Making a Jira automation to create a new ticket every 90 days

[Jackson]

I am relatively new to making Jira automations and I'm looking for help with mine. I am trying to make an automation that will: 

1. Create a new ticket every 90 days to a specific board 

2. Once created, it will send a message to a specific slack channel with a link to the ticket. 

So far I have it set up like this: 

When: Scheduled 

a. every 90 days 

b. I chose "simply run the conditions and actions without providing issues". when I chose "run a JQL search and pass results to subsequent conditions and actions" it ended up creating over 50 tickets before I could turn off the automation. 

Then: Create a new issue

a. selected specific project

b. selected issue type 

c. filled out summary and description 

And: Send Slack message 

a. selected the correct webhook url 

b. added in a message 

c. selected "Send message as Automation for Jira" 

d. added in the correct Slack channel 

[Bill Sheboy]

Hi @Jackson -- Welcome to the Atlassian Community!

For a question like this, please post images of your complete rule and the audit log details showing the rule execution.  Those will provide context for the community to offer suggestions.  Thanks!

If you want to create just one issue, remove the JQL from your trigger.

Are you trying to copy information from other issues to create the new one?

What else is working / not working as you expect for the rule?

Kind regards,
Bill

[Jackson]

I will post screenshots once they are approved. 

I am trying to create an automation that would create a new ticket every 90 days for my team to audit users from a list of apps we use. 

So far when I run the rule it will create a new ticket. When I view the ticket all the correct info is listed. 

The current Issue I am facing is in the Slack message portion. It sends a slack message stating "90 day app audit due" but I can't figure how to add a link to the ticket into the slack message. I would also need to make sure the slack message displays the correct ticket number every 90 days. 

[Bill Sheboy]

After a rule creates the issue, you have the smart value {{createdIssue}} to include any fields in the message: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/#--createdIssue--

One of those is the link to the issue: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/#--issue.url--

Putting those together, you could include the link as:

{{createdIssue.url}}

That link will work for people who have Jira access.

[Jackson]

I'll give that a try, thank you!