Actually I did try that too. Instead of sa the same user as sqlserveragent.

Shahab,

I checked job history  and following error is showing

The job faield: the job was invoked user sa the last step to run was step 1(step1)

PK

Hi shahab,

Thank you for quick response

No I am not getting any error message but big red X is showing front of Optimization job Failed .

GCp7777

Thank you for your help you were  exactly right. It was set on as Simple recovery the minute I have changed from simple to full recovery job has started to...