"Jim Starkey" <jas@...> wrote:

>
> I think this approach has great merit. Defining backup as an external
> procedure would also allow it to be scheduled automatically if/when we
> build in an event scheduler.

CREATE PROCEDURE BACKUP_DATABASE(
PATH VARCHAR(255)
)
AS
BEGIN
EXECUTE STATEMENT 'BACKUP DATABASE TO ' || :PATH;
END

And feel free to schedule it automatically ;-)


Dmitry