Maintenance Cleanup Task - new years bug?

I have a couple of Maintenance tasks running to clean up old files older tha
n
2 days. It has been working fine for the last week, but I checked today and
I
still have files from december in there. Is there some sort of bug with the
date passing newyears and not removing files from the previous year'TJ
As I understood (i could be wrong) this task is still in CTP SP2 and gave
not released yet.
"TJ" <TJ@.discussions.microsoft.com> wrote in message
news:2D4B9235-D132-4061-9726-C7618B1A331B@.microsoft.com...
>I have a couple of Maintenance tasks running to clean up old files older
>than
> 2 days. It has been working fine for the last week, but I checked today
> and I
> still have files from december in there. Is there some sort of bug with
> the
> date passing newyears and not removing files from the previous year'

Maintenance Cleanup Task - new years bug?

I have a couple of Maintenance tasks running to clean up old files older than
2 days. It has been working fine for the last week, but I checked today and I
still have files from december in there. Is there some sort of bug with the
date passing newyears and not removing files from the previous year?
TJ
As I understood (i could be wrong) this task is still in CTP SP2 and gave
not released yet.
"TJ" <TJ@.discussions.microsoft.com> wrote in message
news:2D4B9235-D132-4061-9726-C7618B1A331B@.microsoft.com...
>I have a couple of Maintenance tasks running to clean up old files older
>than
> 2 days. It has been working fine for the last week, but I checked today
> and I
> still have files from december in there. Is there some sort of bug with
> the
> date passing newyears and not removing files from the previous year?

maint. plan fails but doenst report error

Hello

I have this maint. plan where each and every step has been failing the last couple of days. The problem is, it doesn't write anything to the error logs. It only reports to the application log that each step of the plan has failed.

I suspect this might be a user rights problem, but it's difficult for me to say. What kind of rights are necessary for writing to the error logs?

In general, what rights are necessary for the user that runs the SQL Server Agent? And has anybody else experienced something similar?

MNJThis is mostly about scheduling a DTS package as a job. However, the security aspect of it should pertain to your situation as well.

Go Here: http://support.microsoft.com/default.aspx?scid=kb;en-us;269074 (Microsoft Knowledge Base Article 269074)