Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Job is not executed |
Fri, Mar 7 2008 11:25 AM | Permanent Link |
"Uli Becker" | 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 |
Mon, Mar 10 2008 3:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Mar 11 2008 5:27 PM | Permanent Link |
Uli Becker | 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 |
Fri, Mar 14 2008 12:13 PM | Permanent Link |
Uli Becker | 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. |
Fri, Mar 14 2008 3:54 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |