Cancel Report Server Jobs (Management Studio)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Use the Cancel Report Server Jobs dialog box to view or cancel in-progress reports. This dialog box shows all jobs that are currently running on the report server. Although you cannot pause or restart jobs that are currently processing, you can cancel all jobs or individual jobs if they are taking too long to complete.
You can cancel user jobs and system jobs.
A user job is any job that is initiated by an individual user. This includes running a report on-demand, manually creating a report history snapshot, or manually creating report execution snapshot. An in-progress standard subscription is also a user job.
A system job is one that is initiated by the report server. System jobs include scheduled report processing.
To open this page, start SQL Server Management Studio, connect to a report server, right-click Jobs, and then click Cancel All Jobs. You can also open Jobs, right-click a job that is running on the report server, and select Cancel Job(s).
Before cancelling a job, you can view its properties to determine when the job started. For more information, see Job Properties (Management Studio).
This feature is not supported in SQL Server Express with Advanced Services. The page does not appear when you are running SQL Server Express.