Hi

I have created this job, using ElevateDB Manager in a ElevateDB Server :

CREATE JOB "Prova"
RUN AS "System"
FROM DATE '2007-07-01' TO DATE '2050-10-20'
DAILY
BETWEEN TIME '09:40' AND TIME '09:40'
CATEGORY ''
BEGIN
EXECUTE IMMEDIATE 'BACKUP DATABASE Prova
AS Copia
To ''C:\Backups''
INCLUDE CATALOG';
END

If I don't understand bad, every day at 9:40 the server must run a backup.
The job is created ok, but doesn't run never, and field LastRun of Jobs table is allways null.
The server is running ok and the switch Run Jobs is clicked, and Category is empy.

Why the job never runs ?
The server runs the jobs ?

Regards
Robert

Robert,

<< The job is created ok, but doesn't run never, and field LastRun of Jobs
table is allways null. The server is running ok and the switch Run Jobs is
clicked, and Category is empy.

Why the job never runs ? The server runs the jobs ? >>

It's a bug caused by the server not "seeing" the new job.  As a workaround,
if you stop and then restart the server, then it will pick up the new job.

--
Tim Young
Elevate Software
www.elevatesoft.com

<<It's a bug caused by the server not "seeing" the new job.  As a workaround,
if you stop and then restart the server, then it will pick up the new job. >>

This is the problem. Thank you.

Regards
Robert