• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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

0
aatishpatel
Asked:
aatishpatel
  • 2
1 Solution
 
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
 
WizillingCommented:
I am sorry - the above suggestion should be "View History " and not Clew :)
0
 
aatishpatelAuthor Commented:
no problem dude, but atleast got some hint . thanx
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now