How do I Stop a sprint that was Started in Error

[John Lay]

Not paying attention, Sprint 3 was started when Sprint 2 should have been started. We will do Sprint 3, just not now(must be after sprint 2)

I don't want to delete the now started sprint, but need to Stop or pause it while Sprint 2 completes.

[Carlos Garcia Navarro · Accepted solution]

Hi John,

I don't think you can stop a sprint to be restarted later on. You can create a new sprint, and delete the one your started by mistake. The issues that were in Sprint 3 will move to the next sprint. Now you can re-create Sprint 3 and move the original issues back to it.

Hope it helps,

Carlos

[John Lay]

Not the answer I wanted, but the answer I expected.

I did just as you described and I'm back to where I wanted to be.

Thanks @Carlos Garcia Navarro

[Jone Schotten]

Really? 

[Carlos Garcia Navarro]

Hi Jone,

I'm afraid so... Per the Atlassian documentation, "You can only delete inactive sprints, so the ones that haven't been started yet, or that were already completed."

This is an article that explains how to delete sprints:

https://confluence.atlassian.com/jirasoftwareserver075/deleting-a-sprint-935562578.html?_ga=2.73040467.1909076583.1536213038-1642675042.1519882766

[Michael Sedovic]

You can stop it directly in the DB. (Not supported but I do it). 

In the DB the navigate to table AO_60DB71_SPRINT. Locate the sprint in question via the NAME  column then change the value in STARTED from 1 to 0 then save. 

NOTE: Shutdown- make a back up...all that jazz

For me I do it live. Because of the JIRA cache it takes 12+ hours to show via the GUI unless you clear that cache. Scriptrunner has a built in script that does that and use that. I have yet to have a problem with it in 2 years. 

[Eric Wilson]

This actually isn't a terrible solution at least in my case and settings. Create a Sprint, Rename it and move it under the sprint you want to delete. Delete it takes a couple of minutes and it moves it into the newly created sprint. Changing the dates didn't work for me because it would show up in my Kahnbahn view for the active sprint. 

[Matthew Frederes]

The accepted answer is just a hack for a feature that needs to be implemented.  Please vote for JRASERVER-68970

[Jamie Scott]

Done

[cristiana_tamiazzo]

EVERYONE should vote it!

[Arno_Filbig]

just to recap ... only in the DB u can stop a by mistake started Sprint ??????  is there no other way ???   

[Susheela.Kushwaha]

This can be done via UI too, just like Carlos Garcia Navarro mentioned. Here are the steps I followed assuming Sprint1 was started by mistake:

1. Created a temporary sprint

2. Saved the Sprint1 details such as name, start date, and cadence

3. Completed the Sprint1 and moved all issues to the temporary sprint

4. Navigated to the Reports -> Sprint Report and deleted the Sprint1

5. Renamed the temporary sprint with the Sprint1 details

And done!"