OraFAQ Forum: Reports & Discoverer » Oracle Scheduling of reports

Home » Developer & Programmer » Reports & Discoverer » Oracle Scheduling of reports (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Scheduling of reports [message #486481]

Wed, 15 December 2010 23:16

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.

Report message to a moderator

Re: Oracle Scheduling of reports [message #486488 is a reply to message #486481]

Thu, 16 December 2010 00:58

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use operating system scheduler.

Report message to a moderator

Re: Oracle Scheduling of reports [message #486489 is a reply to message #486488]

Thu, 16 December 2010 01:00

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.

Report message to a moderator

Re: Oracle Scheduling of reports [message #486493 is a reply to message #486489]

Thu, 16 December 2010 01:14

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: Oracle Scheduling of reports [message #486498 is a reply to message #486493]

Thu, 16 December 2010 01:22

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 23 11:36:11 CDT 2026