Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED]DMC default email address for E-Mail On Failure
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]DMC default email address for E-Mail On Failure
 Login/Join
 
Platinum Member
posted
Is it possible to set a default email address for E-Mail On Failure in DMC for new flows?
We are on 8.2. DMC version 8203M
Martin.

This message has been edited. Last edited by: Martin vK,


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 152 | Registered: March 29, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
Yes. You can provide a list of e-mail addresses which could be a list of one.

First you need to write a procedure that returns an answer set with an e-Mail address. For example if you create a synonym for a table or file called "addresses" that has a field called "address" that contains an e-mail address then you could use:

TABLE FILE ADDRESSES 
PRINT ADDRESS
ON TABLE PCHOLD FORMAT COMT FORMATTED 
END  


On the Properties Panel under "E-Mail on Failure" check the Advanced button. Click on "Mail to addresses defined in procedure" and select it.
 
Posts: 382 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Cliff,
I think you misunderstood my question. My request was not for a email list.
My question was when I create new flow it automatically contains a default email address for Email on Failure.
Martin.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 152 | Registered: March 29, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
Martin,
DataMigrator User's Guide has "Reference: Scheduler Configuration Dialog Box" which describes how you can set the E-Mail Notification on a server level. Please refer to that section in the manual to see the description of the Scheduler Configuration dialog box. Note: please ensure the password is set on the related user's properties - User ID properties screen.
For example, if you wan to get emails on a start of all flows that Submitted or Scheduled on your server, then you can select the checkbox next to "On Start" parameter and enter the email addresses for the sched_email_address parameter.
This server level setting applies to all flows that don’t explicitly set the email options on the flow levels.

Marina
 
Posts: 34 | Registered: February 13, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Marina, I found it and this is indeed what I was looking for.
Martin.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 152 | Registered: March 29, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED]DMC default email address for E-Mail On Failure

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.