Yes, I would execute it and see if it helps. What version of SQL are you using?

I would also recommend posting your question on the tech net forums because those...

Update:

I've been using MDW and UCP together for months now, and they have been working fine. Apparently the fix I used has made a big difference. I...

Microsoft responded to my post:

Hello,

We are working on fixing this issue in next cumulative update. Please let us know if you would be willing to test this fix on...

No response from Microsoft yet, so I don't know what the official fix for this would be.

But I think I have a workaround in place. The modified...

I had posted a detailed writeup of this issue on the Technet forums. A Microsoft employee responded and pointed me to this blog post. Apparently the reason the...

Hi, sorry I didn't follow up here. I found a blog post that...

OK, I think I tracked it down.

I went to the SQL Agent properties in Management Studio and, under the "Alert System" tab, I checked "Enable Mail Profile", accepting the default...

I also went to the Job properties for Notifications and told it to send a notification via email if the job failed. The notification was never sent.

Update:

Using the "Execute T-SQL Statement" task, I am able to manually send an email when the job fails:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'SharePoint Profile',

...

Update:

This appears to be happening on all my SQL 2008 instances.

I played around with one of my jobs and replaced the On-Failure "Notify Operator" task with a simple "Execute...

Update:

I can run the job manually and it succeeds. All steps execute successfully, and the notification is sent. I can also break the job (by putting in...

Update:

I think I figured out the reason I am not able to upgrade SSRS. The current instance is patched to SP2, and the version on the CD is RTM....

Anyone? Anyone? Bueller?

I'm getting ready to uninstall/reinstall, and migrate databases and configuration as noted here:

http://msdn.microsoft.com/en-us/library/ms143724(SQL.90).aspx

...unless someone has a better idea.

Thanks!

Jonathan Butler (5/23/2008)

---

A few steps and questions about this "problem"

1) are the users in the administrators group on the server running SSIS service

2) If not then DCOM settings need...

I'm having the same issue. I found this tidbit in the BOL, though:

From http://msdn.microsoft.com/en-us/library/ms175915.aspx :

Security Considerations

If a user uses a SQL Server login, the...