Search code examples
pervasivepervasive-sql

Does Pervasive Database have a Scheduler?

Does the Pervasive Control Center (PCC) provide a scheduler? I want to run a sql statement on a schedule. Does Pervasive database offer any type of built-in scheduler, where I can add a statement and specify when it should recur?

Solution

  • No. There is no scheduler provided. You could write a program that executes the query and schedule it using Task Scheduler.

    There is a tool included in recent version of PSQL called PVDDL.EXE that can be used to execute a command file. The command line is:

    pvddl database commandfile
[-separator character] [-username username] [-password password] [-server servername] [-port number] [-stoponfail] [-log logfile]

    Documentation for PVDDL.EXE is at http://docs.actian.com/psql/psqlv13/#page/uguide%2Fuguide.pvddl.htm