CODEWITHSUNDEEP
pervasivepervasive-sql
Lonnie Best
Lonnie Best

Reputation: 11374

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?

Upvotes: 1

Views: 303

Answers (1)

mirtheil
mirtheil

Reputation: 9192

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

Upvotes: 1

Related Questions