Scheduled tasks time/resources limit?

Question

Hello all,

Is there a time limit for the execution of a scheduled task?

I want to make some complex operations, which involves the iteration through all the issues from Jira (aprox. 65000) and saving some data into an external database. I would like to know if such a task can successfully complete and if there is a risk to crash Jira?

richie_gee · Accepted Answer

Timothy made a point here, as long as there is no out of memory issue then it should be fine.

Just another friendly advice, try not to schedule the task at your peak hour as your database is being constantly accessed. Schedule the task to be executed on the graveyard hour and perhaps once every day/week. Do not run on every minute or 10 minute, this process will cause other scheduled task not to be executed on time and delayed.

Also ensure from your database logs, whether does it have some slow queries (taking approximate more than 100 seconds to complete). If yes, then you might encounter performance issue when the schedule task is running. You can verify that from the thread dump.