I defined a job which should start a backup, but nothing happens (Dates and
times are ok) . Server is started and configured, this is the job:

JOB "Backup"
BEGIN
DECLARE DBCursor CURSOR FOR DBStmt;
DECLARE DBName VARCHAR DEFAULT '';
PREPARE DBStmt FROM 'SELECT * FROM Databases where name = ''Informa''';
OPEN DBCursor;
FETCH FIRST FROM DBCursor (Name) INTO DBName;
WHILE NOT EOF(DBCursor) DO
IF (DBName <> 'Configuration') THEN
EXECUTE IMMEDIATE 'BACKUP "' + DBName + '" AS "' +
CAST(CURRENT_DATE AS VARCHAR(10)) +
'-' + DBName + '" TO ''M:\Datensicherung\ElevateDB'' INCLUDE CATALOG';
END IF;
FETCH NEXT FROM DBCursor (Name) INTO DBName;
END WHILE;
CLOSE DBCursor;
END

Am I missing anything?

Uli

Uli,

<< I defined a job which should start a backup, but nothing happens (Dates
and times are ok) . Server is started and configured, this is the job: >>

Did you check the event log ?  You can find it in the EDB Manager under the
tasks pane for the active session (View Logged Events).  There should be an
event in there for the job execution if it executed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<
Did you check the event log ?  You can find it in the EDB Manager under the
tasks pane for the active session (View Logged Events).  There should be an
event in there for the job execution if it executed.
>>

OK, I'll check that.

Uli

Tim,

>
> Did you check the event log ?  You can find it in the EDB Manager under the
> tasks pane for the active session (View Logged Events).  There should be an
> event in there for the job execution if it executed.

There is nothing to be found in the log.

As I never used a job before: am I right, that the job has to be
executed within the EDBManager when I open the database and the
scheduling is correct?

Thanks Uli.

Uli,

<< As I never used a job before: am I right, that the job has to be executed
within the EDBManager when I open the database and the scheduling is
correct? >>

No, that's not correct.  Jobs can only be executed using an ElevateDB Server
currently, although I'm investigating changing this for 2.0 so that local
applications can also run scheduled jobs.

--
Tim Young
Elevate Software
www.elevatesoft.com