Auto e-mail alert

  • From: "Belinda Hamilton" <HamiltBC@xxxxxxx>
  • To: <ora-apps-dba@xxxxxxxxxxxxx>
  • Date: Fri, 11 Jan 2008 15:57:14 -0500

Hello List,
I need to create a e-mail alert that runs every Monday at 3:00.  This will have 
a dynamic mail to address list based on a sql statement.  It does not look like 
the Application Alerts will do this.  It looks like only static distribution 
lists.  
 
I think my alternative is to run a cron job that starts a script that will send 
these e-mails.  Does this sound like the best solution?    Am I missing 
something that would work better that anyone has done or can think of.
 
Many thanks
belinda
 
 


---------------------------------------------------------------
This email, including any attachment(s) to it, is confidential
and intended solely for the use of the individual or entity to
which it is addressed. If you have received this email in error,
please notify the sender. Note that any views or opinions
presented in this email are solely those of the author and do
not represent those of O'Brien & Gere. O'Brien & Gere does not
accept liability for any damage caused by any virus transmitted
by this email. The recipient should check this email and any
attachments for the presence of viruses.
---------------------------------------------------------------

Other related posts: