I want to incorporate functionality that will perform a schedule event (backup).    The manual says;  Scheduled Events - DBISAM allows the definition of scheduled events for a database server. Scheduled events are stored in
the configuration file for the server.

A post on the forum says; The scheduled events are simply something, like several other things in DBISAM, that need to be coded directly into the server.  It's why we ship the source code to the dbsrvr.dpr project.

My question is, where is the configuration file?  And is there documentation anywhere that describes how to do this?

This refers to the server configuration file that you should not edit
directly. Use the server admin tool to access the server and create the
event definition with appropriate schedule.

Then you still need to actually implement what happens when the event
takes place - in the OnServerScheduledEvent.

The manual does actually describe a backup sceanrio so just follow it
under Scheduled Events:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=XE3&topic=Customizing_Engine

Raul

On 5/6/2013 12:19 PM, Owen wrote:
> I want to incorporate functionality that will perform a schedule event (backup).    The manual says;  Scheduled Events - DBISAM allows the definition of scheduled events for a database server. Scheduled events are stored in
> the configuration file for the server.
>
> A post on the forum says; The scheduled events are simply something, like several other things in DBISAM, that need to be coded directly into the server.  It's why we ship the source code to the dbsrvr.dpr project.
>
> My question is, where is the configuration file?  And is there documentation anywhere that describes how to do this?
>

Owen,

<< My question is, where is the configuration file?  And is there
documentation anywhere that describes how to do this? >>

The configuration file is the dbsrvr.scf file that is stored in the same
directory as the dbsrvr.exe file.  It contains all of the database, user,
server-side procedure, and scheduled event definitions for the server.  You
can modify it interactively by using the Server Administration Utility that
comes with this DBISAM download:

http://www.elevatesoft.com/download?action=info&category=dbisam&type=dbisamadd&majorversion=4&version=4.35

And you can modify it programmatically using the information provided here:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Server_Administration

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

With regard to the server utility.  I see status, server, users, databases, database users.  There is nothing listed in our database under  procedures, procedure users and events.  I see how to add a procedure or event, but that seems like name only.    

In other databases I am familiar with one would write some sql that contains a create procedure you could store a procedure in the database and then schedule or run it.  Or you might type it into GUI DBMS tool.  

How do you add the guts of the procedure or event in DBISAM.

I think I am missing something.  

On 5/8/2013 4:43 PM, Owen wrote:
> I see how to add a procedure or event, but that seems like name only.

Correct - you add a name and create the schedule for the event.

And then you need to actually write source code to implement the event
and recompile a custom version of the server.

That's what manual means when it says: "The scheduled events are simply
something, like several other things in DBISAM, that need to be coded
directly into the server".


> In other databases I am familiar with one would write some sql that contains a create procedure you could store a procedure in the database and then schedule or run it.  Or you might type it into GUI DBMS tool.

DBISAM is an mainly an embeddable database engine targeted towards
developers who would implement like backup themselves in their
application and surface an end-user interface for it. There is end-user
ability to do what you want.

The dbsys utility allows you to do on-demand backups manually.

Also you can implement the backup quite easily using just windows file
copy as long as you can shut down the server for brief amount of time:
- stop the dbisam server
- backup the databases (folders) by just making a copy of them (or
zippnig them up or using a file-system backup utility)
- restart the server.

All of the above can be easily done using a windows batch file and
widows built-in scheduling.


> How do you add the guts of the procedure or event in DBISAM.


The manual does actually describe the backup scenario so just follow it
under Scheduled Events (again assumption here is that you have access to
delphi compiler and can recompile the dbsrvr):

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=XE3&topic=Customizing_Engine



Raul

Owen,

<< In other databases I am familiar with one would write some sql that
contains a create procedure you could store a procedure in the database and
then schedule or run it.  Or you might type it into GUI DBMS tool. >>

Our newer product, ElevateDB, works that way.  DBISAM is more geared towards
highly-distributed, embedded databases in Delphi applications, and not as
much general, interactive usage, when it comes to coding certain aspects of
the database such as scheduled events, server-side procedures, and triggers.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Raul and Tim.  That information was helpful.