How to cancel DB request when you cancel a scheduled report that should return a lot of data

The version of the software on the moment of publishing this article is 6.0

Scenario:

• schedule a report that should retrieve a number of records from the database

  
  
  

via the web graphical user interface

• don’t leave scheduler’s user interface window, wait till the moment when

  
  
  

    this report should be executed, at this moment its state should be changed to

    EXECUTING

• click Cancel button to interrupt execution of this report

  
  
  

Result:

• Cancel button deletes job and prevents future executions,

  
  
  

but it does not cancel the SQL query of the job that is in the execution state.

Solution:

• Cancelling a running job can be done via web services, see the "Stopping Running Reports and Jobs" in the web services guide (you should check for job ID in "Scheduled Jobs" screen and cancel the query using REST call while job is being executed).

  
  
  

Other notes:

• the enhancement request regarding this question has been registered that should improve the functionality of this feature in the future releases of the software