Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kuru
Starting Member
2 Posts |
 Posted - 2004-12-07 : 12:59:43
|
| Hello,I am doing a backup on a test database and i have scheduled it for every one hour. It is not working, when ever i start job, then only it is backing up the database. What might be the reason, i am just uing Enterprise Manager GUI options on MS SQL Server 2000. I'll appreciate if any one could show some light on it.thanks in advance.kuru |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-07 : 13:16:59
|
| Is the SQLSERVERAGENT started?Tara |
 |
|
|
kuru
Starting Member
2 Posts |
Posted - 2004-12-08 : 05:58:43
|
| SQL Server Agent is running. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-08 : 21:03:11
|
| is the job enabled?--------------------keeping it simple... |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-12-10 : 06:14:53
|
| from EM->management->sql server agent->jobs select the job you have createdsee the column NEXT RUN DATE....Is this showing the correct time?------------------------I think, therefore I am |
|
|
|
|
|
|
Scheduler is not working in datbase backup