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 |
|
mannu_leo
Starting Member
4 Posts |
 Posted - 2003-12-09 : 10:34:52
|
| Hi all,Whenever I try to run the job through Database Maintenance Plan and it does not run at all. And If I try to run it manually then it actually does nothing. In the Next Run Date Column it says (Date and Time are not available) for any newplans I create. When I right click and say start nothing happens. Its as if newplans are not being recognized in the system but they are enabled and show up injobs.I have checked the SQL Agent Services and these are running with the appropriate rights.And I have checked the logs also and there is nothing there too.I am having SQL 2000 with SP3a on Windows 2000 Standard Server with SP4.Regards,Manoj VermaDBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-09 : 12:30:11
|
| Have you tried recreating the maintenance plan? Sometimes they just get messed up and need to be recreated? Are you able to run any job? Not maintenance plan jobs, but other jobs?Tara |
 |
|
|
mannu_leo
Starting Member
4 Posts |
Posted - 2003-12-09 : 22:30:44
|
| Yes, I created it many times but it never worked. And my database size is also not a constraint. I tried it on a newly created database for this purpose only but still no success. If I try to make a job manually then also its not working. But Transaction Log Backup job through Maintenance Plan is working that too at its scheduled time only. But if I try to run that manually then also its not working.Regards,Manoj VermaDBA |
|
|
|
mannu_leo
Starting Member
4 Posts |
Posted - 2003-12-09 : 23:24:43
|
| Yipppeeeeeeeeeeee....................Reinstallation of SP3a has done the trick. But dont know how...Regards,Manoj VermaDBA |
|
|
|
ras2a
Yak Posting Veteran
66 Posts |
Posted - 2006-07-06 : 06:40:03
|
| I have started having issues with jobs not running. If I re-create them, they run again. The bizarre thing is that I have 1 maintenance plan to backup our main db and logs. This morning, the main db was backed up, but the subsequent tx logs were not being backed up (every 30 mins)- I checked the history and there wasn't even a reference to the job, let alone an error to indicate a possible reason why the job failed. So, I deleted the maintenance plan, re-created it and it's fine again. I've had to do this several times in the past week or so. Weird! |
|
|
|
|
|
|
|
|
Jobs not running at all