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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

State of task via email

Hi Folks, 

i got a Question: Is that possible to make any selection within QMC to make possible any alert-email, when something gone wrong and when everything does work well in QMC.

at the moment i check everyday all my Task manually: i am opening my QMC to check all Status.

 

can i activate any selection to recieve every day the email with Status?

 

Thanks a lot

Beck

Labels (1)
4 Replies
lanlizgu
Creator III
Creator III

In the QMC directly you are not able to configure e-mail alerts.

 

However, if you install the web connectors you are able to aim this.

You need to create two apps and add a task based on the App you want to know if has been updated correctly or not:

  1. The first App will reload in case the Apps reload fails
  2. The second App will reload in case the Apps reload success

These Apps will have a message like follows and will send to the wanted mail the message you want

RestConnectorMasterTable:
SQL SELECT
"status",
"result",
"filesattached"
FROM CSV (header on, delimiter ",", quote """") "CSV_source"
WITH CONNECTION (
QUERY "to" "destination e mail address",
QUERY "subject" "Subject",
QUERY "message" "Message",
QUERY "fronName" "noreply",
QUERY "fromEmail" "email address",
QUERY "format" "csv");

 

You need to create the SMTP connection

 

http://localhost:5555/data?connectorID=SMTPConnector&table=SendEmail&SMTPServer=xxxxx&Port=25&SSLmode=None&to=mail&subject=asdfdsa&message=asdfasdf&html=True&fromName=app-invqlik&fromEmail=mail&delayInSeconds=0&ignoreProxy=False&appID=&asDownload=true&format=csv

beck_bakytbek
Master
Master
Author

Hi Lanlizgu,

 

thanks a lot for your responce. Do you have an example to this issue?

lanlizgu
Creator III
Creator III

Yes, I have examples but can't share.

 

However, if you follow this video you should be able to develop it 

 

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Sending-Emails-with-Qlik-Sense/ta-p/16...

beck_bakytbek
Master
Master
Author

Thanks a lot for your responce, i wll let you know when i solved the issue