error 207 when trying to add a new job

when trying to add a new job via sql agent server, receiving a message:
"error sqlstate: 42s33"
error 207: invalid column name 'category_id'
invalid column name 'netsend_address'
invalid column name 'last_netsend_date'
invalid column name 'last_netsend_time.
Hi,
Did you upgraded your SQL server from older version. If yes then the MSDB
upgrade was not done fully. See the below old post for the step by step
solution.
http://groups.google.com/groups?hl=e...lm=0TDE0%23ZdB
HA.187%40cppssbbsa01.microsoft.com
Thanks
Hari
MCDBA
"ed" <ed@.discussions.microsoft.com> wrote in message
news:99EECA57-E7CC-4F36-A248-F97616029E50@.microsoft.com...
> when trying to add a new job via sql agent server, receiving a message:
> "error sqlstate: 42s33"
> error 207: invalid column name 'category_id'
> invalid column name 'netsend_address'
> invalid column name 'last_netsend_date'
> invalid column name 'last_netsend_time.
|||Hi
-As per SQL Server Books Online "This error (error 207) occurs when a column
referenced in a Transact-SQL statement was not found in any table specified
in
the FROM clause of the query.
-Table msdb..sysoperators didn't have the following columns 'category_id', '
netsend_address',' last_netsend_date',' last_netsend_time'
Looks like some problem with MSDB, try and rebuild as suggested in previous
post.
HTH
Regards
Sadeesh
This posting is provided AS IS with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OBuR4L6cEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Did you upgraded your SQL server from older version. If yes then the MSDB
> upgrade was not done fully. See the below old post for the step by step
> solution.
>
> http://groups.google.com/groups?hl=e...lm=0TDE0%23ZdB
> HA.187%40cppssbbsa01.microsoft.com
> Thanks
> Hari
> MCDBA
> "ed" <ed@.discussions.microsoft.com> wrote in message
> news:99EECA57-E7CC-4F36-A248-F97616029E50@.microsoft.com...
>