We help IT Professionals succeed at work.

Maintenance Plan Job Returns Error

536 Views
Last Modified: 2012-08-13
I get the following error when I execute the job that runs my maintenance plan.  The user running the job has sysadmin privledges.  Is there any way I can get more information on this?

Message
The job failed.  The Job was invoked by User xxxxx.  The last step to run was step 1 (Backup-Scales_Client).

Executed as user: xxxx. The package execution failed.  The step failed.

Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
The step error was the second error I showed above:
Executed as user: xxxx. The package execution failed.  The step failed

I don't see a place to specify a log file in the properties of the job, but i am displaying a log file in the maintenance plan and it show successful:

Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.1406
Report was generated on "xxxxx".
Maintenance Plan: Backup-Scales_Client
Duration: 00:00:00
Status: Succeeded.
Details:


Looks like the backup is done fine, just the job is throwing an error for some reason.

Author

Commented:
I'm not very smart today...the error was because I had renamed a folder and forgot to change my maintenance plan's maintenance cleanup task to reflect that.  So the backup step was working fine, just not the maintenance step.  But its weird that it wouldn't give me a good error to go on.

Commented:
Glad you got it going.  The log I was referring to is specified on the sql agent job, not the maintenance plan.  The maintenance plan generates 1 or more sql agent jobs.  You probably want to go to each job for a plan and specify the a log file.  On a job, edit a step, advanced, and enter a log file (with path).  If you use the same file for each step be sure it is append mode or each step will overwrite the previous.  I'm winging this from memory but it should be close - this is for Sql 2000.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.