Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 error 207 when adding a new job

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-16 : 08:40:07
ed writes "when trying to add a new job via sql server agent, receiving error:

"error sql state 42s22"

error 207: invalid column name 'category_id'
invalid column name 'netsend_address'
invalid column name 'last_netsend_date'
invalid column name 'last_netsend_time'"

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-09-16 : 09:52:18
What is the job doing? My guess is that you haven't set the job to the correct Database...
Go to Top of Page
   

- Advertisement -