Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to stop a job running "sql server analysis services command" Expand / Collapse
Author
Message
Posted Wednesday, September 26, 2012 2:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 7:58 AM
Points: 3, Visits: 112
Hello,

From time to time, a SQL Server job with a step type "sql server analysis services command" is running for ever.

If I try to stop it, SQL Server returns "job stopped successfully" but the job is still shown as running and cannot be restarted (job already running). The only way to really stop it is to restart the SQL Server agent. Is there a way to really stop this Sql server analysis command ?
Post #1364504
Posted Thursday, May 30, 2013 2:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 7:58 AM
Points: 3, Visits: 112
The solution is here : http://sqlmag.com/reporting/managing-analysis-services-activity-14-feb-2010

To show running queries, execute this MDX query :

SELECT * FROM $SYSTEM.DISCOVER_COMMANDS
order by command_start_time
GO
SELECT * FROM $SYSTEM.DISCOVER_SESSIONS
GO
SELECT * FROM $SYSTEM.DISCOVER_CONNECTIONS
GO

Find the forever running query using command_start_time and COMMAND_TEXT.

And then kill the query started by the SQL job using this XMLA query :

<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ConnectionID>xxxx</ConnectionID>
</Cancel>


Thanks a lot Derek !
Post #1458090
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse