create procedure [ssas].[usp_fire_cubeprocesstask] 
(
  @dbId sysname, 
	@cubeId sysname, 
	@mgId sysname, 
	@prtId sysname, 
	@processtype nvarchar(40)='ProcessFull', 
	@currentbatch_priority int = 100,
	@waitforbatch_priority int = 0,
	@uid uniqueidentifier OUTPUT
)
as
begin
 set nocount on;

 declare @msg xml
 declare @sql_str nvarchar(max)

 declare @xmla_str xml = '<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"><Process>
		  <Object><DatabaseID>' + @dbId + '</DatabaseID><CubeID>' + @cubeId + '</CubeID>' 
			+ isnull('<MeasureGroupID>' + @mgId + '</MeasureGroupID>' + isnull('<PartitionID>' + @prtId + '</PartitionID>', ''), '')  + '</Object>
      <Type>' + @processtype + '</Type>
    </Process></Batch>'

   set @sql_str = 'declare @xmla xml = ''' + cast(@xmla_str as nvarchar(max)) + '''
   exec [ssas].[usp_ExecuteXMLA] @xmla=@xmla'

	 set @uid = newid()
   select @msg = (select @uid [@uid], @sql_str [@sql_str], @currentbatch_priority [@curr], @waitforbatch_priority [@wfor], sysdatetime() [@snd_time] for xml path('cmd'));
   exec [async].[usp_async_enqueue] @msg
end

  if @server = 'srv1' or  @server = '.' or @server = 'localhost'
    exec (@cmd) AT srv1
  else if @server = 'srv2'
    exec (@cmd) AT srv2
  else if @server = 'srv3'
    exec (@cmd) AT srv3
  else
    в лог ошибок