Scheduled backup

I just loaded SQL 2000 sp3a on a Windows 2003 server and
copied a 7.0 database over from another server to test.
I scheduled a backup for everyday at 1:00 am and noticed
that it did not do it last night.
It looks like the SQL server agent is set up and waiting
to run but it didn't.
What am I missing?In EM, Management, Jobs ensure Enabled = Yes, Scheduled = Yes , Runnable =Yes
--
HTH
Ryan Waight, MCDBA, MCSE
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:11c001c3b435$12c0fdd0$a301280a@.phx.gbl...
> I just loaded SQL 2000 sp3a on a Windows 2003 server and
> copied a 7.0 database over from another server to test.
> I scheduled a backup for everyday at 1:00 am and noticed
> that it did not do it last night.
> It looks like the SQL server agent is set up and waiting
> to run but it didn't.
> What am I missing?
>|||Paul
A few ideas.
Most obvious, is SQL Agent running?
If it is have you checked the time on the server. If the
time is incorrect you may find your job kicking off any
time. Or have you changed the time on the server since
setting up the job. If you have re-create the job.
Have you looked in the Windows event log? If there are any
permissions problems you will see them there.
Hope this helps
John