error adding new job from sql server agent

[edwardb15]

receiving the below error when trying to add a new job from sql server agent:

SQL-DMO ODBC Sqlstate: 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'.

the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

 

[hmckillop]

If you are using Enterprise manager to setup your job, please ensure you select the correct database for your job to run at.
Alternatively if you are scripting include the line :

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep 
		@job_id = @JobID, 
		@step_id = 1, 
		@step_name = N'Job Stepname', 
		@command = N'TSQl Command in here', 
		@database_name = N'MyDatabaseName' --this is the important line

"Own only what you can carry with you; know language, know countries, know people. Let your memory be your travel bag.

 

[edwardb15]

thanks for the reply, hmckillop.
i also found that those columns were missing from some of the system tables. don't know how or why? restored msdb from backup.