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

    Frequency	Interval
    Every 15 minutes	sysdate+1/96
    Every 30 minutes	sysdate+1/48
    Every hour	sysdate+1/24
    Every 2 hours	sysdate+1/12
    Every 4 hours	sysdate+1/6
    Daily at midnight	trunk(sysdate+1)
    Every 30 days at midnight	trunk(sysdate+30)
    Every 90 days at midnight	trunk(sysdate+90)