How do I schedule a database job?

• PENTA for Windows

• Schedule Database Jobs

• Open the Schedule Database Jobs window

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

Open

• 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

    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)