Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2007-08-08
5
Medium Priority
?
5,906 Views
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)
Messages
Adding scheduling options failed.

------------------------------
ADDITIONAL INFORMATION:

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
 

- Adding reporting options (Stopped)

- Saving maintenance plan "MaintenancePlan1" (Stopped)

Any ideas?
0
Comment
Question by:lostboyinsofla
5 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 2000 total points
ID: 19654336
These columns were added in SP2. Check your installer logs and see if SP2 setup ran without error.
0
 

Author Comment

by:lostboyinsofla
ID: 19654811
I'm having trouble finding the log files.  Do you know where they are?
0
 

Author Comment

by:lostboyinsofla
ID: 19657471
Ok I finally got the damn thing installed.  Still not sure what was wrong though.  Rebooted the server and it installed fine.
0
 

Expert Comment

by:MikeLenz
ID: 23203154
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.
0
 

Expert Comment

by:mirde
ID: 26558950
Hi,
 
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?
Thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

578 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