Invalid column name 'msx_job_id' (Microsoft SQL Server, Error: 207)

Posted on 2007-08-08
Last Modified: 2013-11-05
I am trying to create a maint. plan in SQL Server 2005 SP2.  I get the error below:

Maintenance Plan Wizard Progress

- Creating maintenance plan "MaintenancePlan1" (Success)

- Adding tasks to the maintenance plan (Success)

- Adding scheduling options (Error)
Adding scheduling options failed.


Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Invalid column name 'msx_job_id'. (Microsoft SQL Server, Error: 207)

For help, click:

- Adding reporting options (Stopped)

- Saving maintenance plan "MaintenancePlan1" (Stopped)

Any ideas?
Question by:lostboyinsofla
    LVL 20

    Accepted Solution

    These columns were added in SP2. Check your installer logs and see if SP2 setup ran without error.

    Author Comment

    I'm having trouble finding the log files.  Do you know where they are?

    Author Comment

    Ok I finally got the damn thing installed.  Still not sure what was wrong though.  Rebooted the server and it installed fine.

    Expert Comment

    this problem occurs if some of the stored procedures while installing SP2 has not been applied successfully. So we will manually run one of the stored procedure. And hopefully this issue will get resolved.

    1)       First go to the folder Install . The default location is this = C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install  .
    2)      Then in this folder find this sysdbupg.sql .
    3)      Please open this script with a nodepad.
    4)      Then copy the whole script and then paste it in the Query window of the Management studio.
    5)      Then execute this script.
    6)      Once this script has been successfully executed, The issue should be resolved.

    Expert Comment

    How safe is it to re-run the "sysdbupg.sql" script on a production SQL Server that has the same error?
    I cannot create a maintenance plan either, get the same error. My verion is SP2, I think the person that used to manage the DB before failed to update it correctly.
    Any thoughts?

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    754 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

    25 Experts available now in Live!

    Get 1:1 Help Now