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

Thread: scheduling jobs

  1. #1
    Join Date
    Jun 2003

    scheduling jobs


    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.



  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    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