Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you have any questions or need access: Contact myibi@ibi.com


Connect to myibi
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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report 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.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report 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 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report 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: 37 | Registered: February 13, 2007Report This Post
Platinum Member
posted Hide Post
Thanks Marina, I found it and this is indeed what I was looking for.
Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders