SQL Server

I have a job that runs every friday evening after hours. Actually its a database maintenance plan.     owner is ustc.     category is database maintenance.     but this job fails every week. please help me to solve this.
/SQL "Maintenance Plans\ Maintenance Plan" /SERVER "tra-done-sql-04"  /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false /REPORTING E

Open in new window

aatishpatelAsked:
Who is Participating?
 
WizillingCommented:
I am sorry - the above suggestion should be "View History " and not Clew :)
0
 
chapmandewCommented:
does it give you a reason why it fails?
0
 
WizillingCommented:
Right click the job and select "Ciew history"
you might need to expand the + sign to go into the detail of the steps .
check for error messages there .
0
 
aatishpatelAuthor Commented:
no problem dude, but atleast got some hint . thanx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.