Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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
Hi Lanlizgu,
thanks a lot for your responce. Do you have an example to this issue?
Yes, I have examples but can't share.
However, if you follow this video you should be able to develop it
Thanks a lot for your responce, i wll let you know when i solved the issue