Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Run macros in QMC

HI Guys,

I've got a problem when i run my  QV model manually on a server it runs and send me an email with an attachment Via Macros,

but when i use QMC it dosen't send and email and it dosen't give me any problems with the macros.

* i did allowed Macro execution on a server together with unsafe macros

so im not sure on how to tackle this??

Urgent help will be beneficial.

Thanks.

13 Replies
jerrysvensson
Partner - Specialist II
Partner - Specialist II

Then you can use Windows Task scheduler instead.

- Create a batch file

- In said file, issue %PATH-TO-QV.exe%\qv.exe /r path-to-qvw-doc.qvw

Schedule the batch file.

Not applicable
Author

Hi Jerry,

not sure on how to get to that,

i can only go to Task Scheduler, from there i don't see where i can create In Said File.

Please assist.

jerrysvensson
Partner - Specialist II
Partner - Specialist II

You create batch file on your filesystem and then Schedule that in Task scheduler. If you don't know how to do it I suggest you ask your IT to help you.

magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi.

See attached screenshots.

PS: You need QV Publisher for this to work, else you need to do as our good Mr. JERRYSVENSSON‌ suggests here: Re: How to Run macros in QMC

QMC -> System -> Supporting Tasks -> [Publisher Node] -> External Program -> Add Task

QMC-System-Supporting-Tasks-ExternalProgram.png

QMC-System-Supporting-Tasks-ExternalProgram-AddTask.png

Hope it helps.

// Regards

Magnus ÅVITSLAND

Business Intelligence Architect