Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2011
    Posts
    8

    Unanswered: Query Scheduling Apps

    Hi all,

    Im looking for an application that can both schedule queries and generate reports to several formats (including xls and csv).

    I just want to be able to open an sql file and schedule it weekly or whatever. Exporting the file to a location will be fine, mailing it would be a nice option.

    Do you have any suggestions?

    (what have I done
    Used SQLPLUS spooling, doesnt cut it for me, it should be much easier.
    Looked into Procedures and UTL_FILE etc, seems viable but still very complicated.

    ORACLE 10g 10.2.0.3.0

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    What are the license requirements for BI?

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Business Intelligence Publisher License

    Or you can try the Oracle Developer Suite which has "Oracle Business Intelligence Discoverer"

    Last edited by LKBrwn_DBA; 02-14-11 at 13:12.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •