![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Fri, Jun 8 2007 9:29 PM | Permanent Link |
Alfred Ghazzi | Hi
I want to create a job that runs at scheduled times for backing up the database. I created the backup SQL Statement and paste it in database SQL window it worked fine and created the Backup file. When I paste it in the SQL window in Job dialog it came with an error to the affect that the statement should have been statred with select, insert, delete, etc.... but instead Backup is found... Please can you advise me whether the Backup statement can be called inside a job? and how? if not how else can I schedule the backup? Many Thanks |
Mon, Jun 11 2007 3:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Alfred,
<< When I paste it in the SQL window in Job dialog it came with an error to the affect that the statement should have been statred with select, insert, delete, etc.... but instead Backup is found... Please can you advise me whether the Backup statement can be called inside a job? and how? if not how else can I schedule the backup? >> See this example here: http://www.elevatesoft.com/edb1sql_create_job.htm All SQL statements in SQL/PSM (procedures, functions, jobs, triggers) require that you use EXECUTE or EXECUTE IMMEDIATE to execute the statement. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Jun 11 2007 11:36 PM | Permanent Link |
Alfred Ghazzi | My apologies Tim
Being very busy; I went through the Create JOB in the manual but somhow missed reading the example (which is exactly what I wanted to do) ![]() Thank you very much (Excellent Service) Alfred |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |