/*
Данный скрипт был применен в DocsVision версии 5.4
*/
declare @cid uniqueidentifier
declare @UserID uniqueidentifier
declare @SessionID uniqueidentifier
set @UserID =(select top 1 UserID from dbo.dvsys_users where AccountName ='domain\hyper')
set @SessionID = (select top 1 SessionID from dbo.dvsys_sessions where UserID = @USerID)
if (@UserID is not null) and (@SessionID is not null)
begin
declare cur cursor for
select InstanceID from
dbo.[dvtable_{0EF6BCCA-7A09-4027-A3A2-D2EEECA1BF4D}]
where State=3 and Name like '%Экземпляр подпроцесса УД Отправка почтовых уведомлений%'
open cur
fetch next from cur into @cid
while @@fetch_status=0
begin
EXEC [dbo].[dvsys_card_delete] @UserID,@SessionID, @cid,1
fetch next from cur into @cid
end
close cur
deallocate cur
end
Данный скрипт был применен в DocsVision версии 5.4
*/
declare @cid uniqueidentifier
declare @UserID uniqueidentifier
declare @SessionID uniqueidentifier
set @UserID =(select top 1 UserID from dbo.dvsys_users where AccountName ='domain\hyper')
set @SessionID = (select top 1 SessionID from dbo.dvsys_sessions where UserID = @USerID)
if (@UserID is not null) and (@SessionID is not null)
begin
declare cur cursor for
select InstanceID from
dbo.[dvtable_{0EF6BCCA-7A09-4027-A3A2-D2EEECA1BF4D}]
where State=3 and Name like '%Экземпляр подпроцесса УД Отправка почтовых уведомлений%'
open cur
fetch next from cur into @cid
while @@fetch_status=0
begin
EXEC [dbo].[dvsys_card_delete] @UserID,@SessionID, @cid,1
fetch next from cur into @cid
end
close cur
deallocate cur
end
Комментариев нет:
Отправить комментарий