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

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

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