Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Issue/Symptom/Question

How do I schedule a database job?

Applies To

  • PENTA for Windows
  • Schedule Database Jobs window

Resolution/Fix/Answer

  • Open the Schedule Database Jobs window
    • System Management > Technical Support > Penta Technologies Inc. Technical Support > Schedule Database Jobs

...

  • Scroll through the list of jobs to find the one relevant to you
  • In the Active column, mark the job as Active (Y) or Inactive (N)
  • In the Next Scheduled Date and Time columns choose the next date and time that the job should run
  • In the Interval column enter how often the job should run
    • Sample Intervals

      FrequencyInterval
      Every 15 minutessysdate+1/96
      Every 30 minutessysdate+1/48
      Every hoursysdate+1/24
      Every 2 hourssysdate+1/12
      Every 4 hourssysdate+1/6
      Daily at midnighttrunk(sysdate+1)
      Every 30 days at midnighttrunk(sysdate+30)
      Every 90 days at midnighttrunk(sysdate+90)