June 9, 2008 at 3:18 pm
Microsoft SQL Server Management Studio version 9.00.3042.00
The Maintenance plan will not run and I get no automated backups.
The SQLServer Logs do not mention anything.
The System Events > Application Log shows all the failures.
Status: Failed. Involed on: at the scheduled time - message: The job failed. the Job was invoked by Schedule 1 (Maintenance Plan.subplan). The last step to run was step 1 (Subplan).
Step 1 is Check Database Integrity, include indexes
Step 2 is Reorganize index
I can manually do a full backup of the database (which I do daily), but the Maintenance Plan does not run.
This Maintenance plan had run previously, but since I tried to configure the server to send me a daily report on the status of the Backup jobs, it stopped working.
I can successfully send myself a test e-mail from the server, but I have removed all the settings that I had changed when trying to get the e-mail function to work. I am not even sure if the two are connected - my messing with the e-mail functionality and the Maintenance Plan not running anymore.
Any ideas?
June 11, 2008 at 9:33 am
Paul, Please try to do it from scrach and make sure you test your SMTP/DB mail option in MSDB DB as well.
After creation of the DBtry to refresh the DB and server.
MCP, MCTS (GDBA/EDA)
June 11, 2008 at 12:11 pm
If you expand the job execution history, you should see that for every step, it has a summary too.
Please post the error message you are getting.
If it indicates a Database Mail problem, go to Management -> Database Mail and right click to "Send Test E-mail". Make sure Database Mail is working correctly.
June 18, 2008 at 4:16 am
you have to set two value in regisry.
in run type regedit
then microsoft sql server folder there is sqlserver agent folder
in that two value you have to send
1)usedatabasevalue to 1
2)databasemailprofile to your profilename
June 18, 2008 at 5:29 am
4. Open the registry editor by going to Start > Run > regedit.
5. Browse to the "SQLServerAgent" section. The path is something like
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\SQLServerAgent".
6. Modify the following entries with the corresponding values listed below.
Key Value
----------------------------------------------------------
UseDatabaseMail 1
DatabaseMailProfile Default Profile
7. Restart the "SQL Server Agent" service and voila!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply