Home > Archive > microsoft.public.sqlserver.server > November 2002 > Error creating Scheduled Jobs





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Error creating Scheduled Jobs
=?iso-8859-1?Q?Emiliano_Fern=E1ndez?=

2002-11-28, 11:23 am

Hello everybody:

We have a problem creating scheduled jobs. The message is
the following:

Title: Microsoft SQL-DMO (ODBC SQLSTATE 42522)
Description: Error 207
The column name category_id is invalid
The column netsend_address is invalid
The column name last_netsend_day is invalid
The column name last_netsend_time is invalid

This message appears when trying to create a new job from
the context menu in the jobs section.
Tibor Karaszi

2002-11-29, 1:23 am

Did you upgrade you SQL Server? It seems like msdb isn't what it should be. Did you search KB
(your problem rings a bell to me, so there is a good chance for a KB article)?

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver


"Emiliano Fernández" <efernandez@fund.uc3m.es> wrote in message
news:1d54b01c296fc$6f7cf3a0$89
f82ecf@TK2MSFTNGXA01...
> Hello everybody:
>
> We have a problem creating scheduled jobs. The message is
> the following:
>
> Title: Microsoft SQL-DMO (ODBC SQLSTATE 42522)
> Description: Error 207
> The column name category_id is invalid
> The column netsend_address is invalid
> The column name last_netsend_day is invalid
> The column name last_netsend_time is invalid
>
> This message appears when trying to create a new job from
> the context menu in the jobs section.



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net