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 need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
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
ON TABLE PCHOLD FORMAT COMT FORMATTED
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: 397 | Location: New York City | Registered: May 03, 2007
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
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.