Home » Developer & Programmer » Reports & Discoverer » Oracle Scheduling of reports (Oracle 10g)
Oracle Scheduling of reports [message #486481] Wed, 15 December 2010 23:16 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

I want to run some reports based on certain schedule lets say after 1 hour or 2 hours may be send an email.How to do it.
Re: Oracle Scheduling of reports [message #486488 is a reply to message #486481] Thu, 16 December 2010 00:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use operating system scheduler.
Re: Oracle Scheduling of reports [message #486489 is a reply to message #486488] Thu, 16 December 2010 01:00 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

actually i want to implement that scheduler in UTL_MAIL like at 10pm email should be sent to some persons like reminder.
Re: Oracle Scheduling of reports [message #486493 is a reply to message #486489] Thu, 16 December 2010 01:14 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
First you have to run a report. Its result is a file.
Then you have to e-mail that file to someone.

So, from my point of view, involving a database (i.e. UTL_MAIL) into e-mailing a file is something you don't need, as operating system's scheduler can do that.
Re: Oracle Scheduling of reports [message #486498 is a reply to message #486493] Thu, 16 December 2010 01:22 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

I agree with you littlefoot but in case if dont want to use report and run the query instead and send the query contents thru database trigger while inserting or is there any workaround , as somehow i need to send intimation that they need to do the task.
Previous Topic: Creating data link using a column only selected in one group
Next Topic: Using a parameter for Maximum rows to fetch
Goto Forum:
  


Current Time: Thu Mar 28 16:27:58 CDT 2024