Ending an external task

Mon, 26 Jan 2026 18:19:17 GMT

Hi,
I started an external task, which execute a macro, which sends an Excel Table via Email, in an QlikView Document.

The task runs succsessfully and I recieve the email, but in the Enterprise Management Console the Task is running wihtout ending, weather the Mail have been distributed. So, every time I have to stop the reload by myself and the reload fails.

What can I do, that the reload stops itself, when finishing distirbution?
Here's the VBA-Script from my QlikView document:

'################################EMAIL-HANDLING FUNCTION#################################

Public Function SendMail (SendTo, Subject, Body, Attachment)
', Attachment, SendCC, SendBCC)

Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = Subject
objMessage.From = "QlikviewPublisher@XXX.de"
objMessage.To = SendTo
objMessage.CC = SendCC
objMessage.BCC = SendBCC
objMessage.TextBody = Body
'msgbox Attachment
if( not "" = Attachment) then
objMessage.AddAttachment Attachment
end if

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "RE-XX.XX-XX.TEDA"

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

objMessage.Configuration.Fields.Update

objMessage.Send
End Function

sub email()
'Set oShell = CreateObject("WScript.Shell")'
'set fso = CreateObject("Scripting.FileSystemObject")
path = "C:\Temp\Myexport.xls"
'If fso.FileExists(path) Then
'set excelFile = fso.GetFile(path)
'excelFile.Delete
'end if

Application.Sleep(1000)

set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportBiff path

Application.Sleep(1000)

call sendmail("test.test@email.de", "Your Excel report","See attached Excel doc for details for last 30 days. The full QV report is here: https://xxx.com/xyz", path)
'ActiveDocument.GetVariable("sendTo").GetContent.String'

ActiveDocument.ClearAll False

end sub

'########################################################################################################'

Thanks for help.

Ending an external task

Tue, 13 Jul 2010 20:40:04 GMT

you might want to look into this to compare 🙂

http://community.qlik.com/media/p/64479.aspx

Ending an external task

rwunderlich — Tue, 13 Jul 2010 21:44:01 GMT

What is the command line of your external task?

-Rob

Re: Ending an external task

Thu, 15 Nov 2012 12:42:01 GMT

Ciao Francesco,

anch'io ho problemi con un task esterno (nella Command line statement c'è scritto: C:\SW_CTRL_LOG_QLIK\QlikLauncher.exe 1 dove 1 è un parametro per l'eseguibile) che fa tutto quello che deve ma alla fine, invece di terminare, resta appeso.

Ho tentato di accedere al link http://community.qlik.com/media/p/64479.aspx per vedere la tua risposta ma sembra che la pagina non sia più raggiungibile.

Mi puoi scrivere per favore, qual è la soluzione che suggerivi?

Grazie mille

topic Ending an external task in QlikView

Ending an external task

Ending an external task

Ending an external task

Re: Ending an external task