I have fixed the probloem.

change the Account that START the Agent Service .the defalt user is system.

I change to administrator.

Change the owner of the job to administrator too.

then fixed.

I had met the same problem few months ago.

I found that was coused by the BIG sql . just like the update in a huge table ,you may monitor the...

--descript:cycle all the index in all talbe when then fragment is too big it will built a sql to rebuild or reorganize it

declare @tablename nvarchar(50)

declare @idx_id int,@idx_name nvarchar(50),@idx_fragment float

declare @cmd...