scheduling jobs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: scheduling jobs

  1. #1
    Join Date
    Jun 2003
    Posts
    24

    scheduling jobs

    Hi,

    I have to schedule print jobs on Oracle 9i DB.
    The Report table structure is as below

    RepJobID PrintJobDt RepoFreq
    ------------------------------
    1 14/10/2004 1
    2 02/12/2004 2
    3 10/09/2004 3
    4 09/11/2004 1

    RepoFreq: 1 - weekly, 2 monthly, 3 daily

    PrintJobDt: is the date from when the Report should start printing. This date
    will not be changed after the report is printed.

    I have to have a DBMS_JOB running each day morning, which will query this table. And schedule priniting of each report based on the report frequency (RepoFreq), from the
    Day the Report has to start printing for the first time (PrintJobDt).
    Weekly report means should print for 7 days. The last report printed date
    is not stored in any tables.

    Thanx.

    sam

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    You should create a PL/SQL procedure to schedule the right report on the right day.
    this space intentionally left blank

Posting Permissions

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



Click Here to Expand Forum to Full Width