SQL Server issues (Maintenance plan)

[Former Member]

Hi All,

Whenever I am trying to create maintenance plan in SQL Server, getting the following errors in scheduling error

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

Regards,

Rupa Sarkar

[Former Member · Accepted solution]

Hi,

The error comes when some column names were not added in SP2 while installing sql server

Follow below steps:

1) First go to the folder Install . The default location is this = u201CC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install u201C .
2) Then in this folder find this u201Csysdbupg.sqlu201D . 
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. 

Thanks,

Neetu