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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Maintenace plan not executing in 2005

Author  Topic 

kneel
Starting Member

36 Posts

Posted - 2008-05-01 : 11:53:57
Hello All,

Few days before, I had setup Maintanance plan for taking backup in 2005. It was running nice.But suddenly it stops automatically. It is not creating log file too.

Does anyone faced this type of problem ? Or does anybody knows the workaround for this.
Thanks in advance

--kneel

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-05-03 : 08:00:28
Could you confirm it's enabled?
You could also try to run the job by doing a right click and Start Job , just to confirm .it's running as it should


Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-03 : 14:36:02
post the error you got.
Go to Top of Page

kneel
Starting Member

36 Posts

Posted - 2008-05-04 : 16:30:44
Hello All,

Thanks a lot. SQL server Agent was disabled. My problem solved.

Tons of thanks



--kneel
Go to Top of Page
   

- Advertisement -