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,

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.

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.

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

Thanks Marina, I found it and this is indeed what I was looking for.
Martin.