Maintenance Plan Job Returns Error

Posted on 2007-10-10
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?

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.

Question by:Fraser_Admin
    LVL 21

    Accepted Solution

    Look at the job history with the "show steps" checked and highlight the last step - this might show details.  More likely go to the job itself for the step that failed, properties, advanced, and specify a log file then rerun the job and check the log file.

    Author Comment

    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.

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

    Author Comment

    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.
    LVL 21

    Expert Comment

    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.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now