Notify Report success/failure by mail

You can change the report configuration to notify the report failure or success by mail as below. Set Notification tag and pluginparam in report server's configuration file . Failnote.txt and succnote.txt files are found under
MT_OH\reports\templates

<?xml version = '1.0' encoding = 'ISO-8859-1'?><br /> <!DOCTYPE server PUBLIC "-//Oracle Corp.//DTD Reports Server Configuration //EN" "file:D:\AS_mt\reports/dtd/rwserverconf.dtd"><br /> <server version="10.1.2.3.0"><br /> <!--Please do not change the id for reports engine.--><br /> <!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.--><br /> <cache class="oracle.reports.cache.RWCache"><br /> <property name="cacheSize" value="2048"/><br /> <!--property name="cacheDir" value="your cache directory"--><br /> <!--property name="maxCacheFileNumber" value="max number of cache files"--><br /> <!--property name="ignoreParameters" value="parameter names to be ignored in constructing cache key, separated by comma ','"--><br /> </cache><br /> <engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="4" maxEngine="16" minEngine="1" engLife="1" maxIdle="30" callbackTimeOut="90000" engineResponseTimeOut="20"><br /> <!--property name="sourceDir" value="your reports source directory"/--><br /> <!--property name="tempDir" value="your reports temp directory"/--><br /> <!--property name="keepConnection" value="yes"/--><br /> </engine><br /> <engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000"/><br /> <!--security id="rwSec" class="oracle.reports.server.RWSecurity"><br /> <property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/><br /> <property name="oidEntity" value="%REPORTS_OID_ENTITY%"/><br /> </security--><br /> <!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal"><br /> <property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/><br /> </destination--><br /> <destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP"><br /> <!--property name="proxy" value="proxyinfo.xml"/--><br /> </destination><br /> <destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV"><br /> <!--property name="proxy" value="proxyinfo.xml"/--><br /> </destination><br /> <!-- By default server will use rwnetwork.conf as network config file Use this element to override the same --><br /> <!--networkConfig file="rwnetwork.conf"></networkConfig--><br /> <job jobType="report" engineId="rwEng"/><br /> <job jobType="rwurl" engineId="rwURLEng"/><br /> <notification id="mailNotify" class="oracle.reports.server.MailNotify"><br /> <property name="succnotefile" value="succnote.txt"/><br /> <property name="failnotefile" value="failnote.txt"/><br /> <property name="sender" value="inam@domain.com"/><br /> </notification><br /> <!--notification id="wfNotify" class="oracle.reports.server.WorkflowNotify"><br /> <property name="connStr" value="%WF_DB_USERNAME%/%WF_DB_PASSWORD%@%WF_DB_TNSNAME%" confidential="yes" encrypted="no"/><br /> </notification--><br /> <log option="noJob"/><br /> <!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB"><br /> <property name="repositoryConn" value="repo_db_username/repo_db_password@repo_db_tnsname" confidential="yes" encrypted="no"/><br /> </jobStatusRepository--><br /> <!--trace traceOpts="trace_all"/--><br /> <trace traceMode="trace_append" traceOpts="trace_err"/><br /> <connection maxConnect="180" idleTimeOut="20"><br /> <orbclient id="RWClient" publicKeyFile="clientpub.key"/><br /> </connection><br /> <queue maxQueueSize="1000"/><br /> <!--jobRecovery auxDatFiles="yes"/--><br /> <!-- The value of the 'identifier' element is encrypted and is of the form SERVERACCESSKEY_USER/SERVERACCESSKEY_PASSWORD SERVERACCESSKEY_USER and SERVERACCESSKEY_PASSWORD in <server>.conf and targets.xml<br /> file should match for Reports EM pages to display data correctly.<br /> <br /> Corresponding entries of username and password in targets.xml:<br /> <property NAME="Password" VALUE="SERVERACCESSKEY_PASSWORD" ENCRYPTED="FALSE"/><br /> <property NAME="UserName" VALUE="SERVERACCESSKEY_USER" ENCRYPTED="FALSE"/> <br /> --><br /> <identifier confidential="yes" encrypted="yes">RgBfDF3tNEyDwMg=</identifier><br /> <!--pluginParam name="mailServer">%MAILSERVER_NAME%</pluginParam--><br /> <!--pluginParam name="proxy" type="file">proxyinfo.xml</pluginParam--><br /> <pluginparam name="xmlpds" type="file">xmlpds.conf</pluginParam><br /> <pluginparam name="jdbcpds" type="file">jdbcpds.conf</pluginParam><br /> <pluginparam name="textpds" type="file">textpds.conf</pluginParam><br /> <pluginparam name="mailServer">mail.domain.com</pluginParam><br /> </server>

Failnote.txt

Report Server:  &servername
Time:  &timefinished

The Job &jobname  has terminated.

Error String:  &errorstring

-----------------------------------------------------------------------
Note: This mail was automatically generated by the Report Server  &servername on OAS1
Oracle Application Server

Succnote.txt

Report Server:  &servername
Time:  &timefinished

The Job &jobname  has successfully finished
----------------------------------------------------------------------------------------
Note: This mail was automatically generated by the Report Server  &servername on OAS1
Oracle Application Server