E r ro r S Q L S e r v e r : 1 4 2 6 2

Last Post 19 Mar 2010 04:09 AM by rm. 7 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
regis bachelin
New Member
New Member

--
17 Mar 2010 04:15 AM
Hello,

with SQLServer2000, the log fileSQLAgent is full with this kind of error :

! [ 2 9 8 ] E r r o r S Q L S e r v e r : 1 4 2 6 2 , T h e @ j o b _ i d ( ' 3 D 0 6 D F 3 9 - 4 8 6 7 - 4 0 6 C - B A 3 9 - 2 2 8 E E 5 3 0 F C 9 A ' ) s p e c i f i e d ' d o e s n o t e x i s t . [ S Q L S T A T E 4 2 0 0 0 ] ( C o n n E x e c u t e C a c h a b l e O p )

Do you know where this issue come from ?

The indicated jod_id is not present in the table msdb.sysjobs, do you know in which table i can find it in order to delete it?

Thanks.

Régis
rm
New Member
New Member

--
17 Mar 2010 05:13 AM
Did you set master server on it? Tried restart sql agent?
regis bachelin
New Member
New Member

--
17 Mar 2010 06:29 AM
Hello and thanks for your reply.

Did you set master server on it?

I don't know what does it mean.

Tried restart sql agent?

I reboot the serveur without success.


rm
New Member
New Member

--
17 Mar 2010 01:05 PM
Master server means can run sql jobs from other servers.
regis bachelin
New Member
New Member

--
17 Mar 2010 11:50 PM

Posted By rm on 17 Mar 2010 04:05 PM
Master server means can run sql jobs from other servers.


I have everything on the same serveur, I don't have any sql jobs on other serveur.

Do you know, where I can find the id jobs ? These id jobs are not present in the table sysjobs but apparear and fill the log SQLAGENT.

Regards,

Régis
rm
New Member
New Member

--
18 Mar 2010 04:52 AM
Only place is msdb..sysjobs. Any other error in sql agent error log? Any related message in sql server log?
regis bachelin
New Member
New Member

--
18 Mar 2010 05:45 AM

Posted By rm on 18 Mar 2010 07:52 AM
Only place is msdb..sysjobs. Any other error in sql agent error log? Any related message in sql server log?


Nothing more, only these kind of messages :

2010-01-28 22:06:52 - ! [298] Erreur SQLServer : 14262, Le @job_id ('2100F993-C469-495C-8B4C-1AA4E7E3CAEF') spécifié n'existe pas. [SQLSTATE 42000] (ConnExecuteCachableOp)
2010-01-28 22:06:52 - ! [298] Erreur SQLServer : 14262, Le @job_id ('2C9FE39E-3E04-4484-8D55-57C8A69394B5') spécifié n'existe pas. [SQLSTATE 42000] (ConnExecuteCachableOp)
2010-01-28 22:06:52 - ! [298] Erreur SQLServer : 14262, Le @job_id ('F1B13101-B020-404E-8678-A48FCD88A253') spécifié n'existe pas. [SQLSTATE 42000] (ConnExecuteCachableOp)
2010-01-28 22:06:52 - ! [298] Erreur SQLServer : 14262, Le @job_id ('B8F375FE-737E-419E-940F-6B5B2FDEC7DF') spécifié n'existe pas. [SQLSTATE 42000] (ConnExecuteCachableOp)
2010-01-28 22:06:52 - ! [298] Erreur SQLServer : 14262, Le @job_id ('2A50486C-E634-4A50-A596-F629B2E361A0') spécifié n'existe pas. [SQLSTATE 42000] (ConnExecuteCachableOp)
2010-01-28 22:06:52 - ! [298] Erreur SQLServer : 14262, Le @job_id ('D72F652D-5A43-4AE2-99D9-F2DC9DF07AE9') spécifié n'existe pas. [SQLSTATE 42000] (ConnExecuteCachableOp)
2010-01-28 22:06:52 - ! [298] Erreur SQLServer : 14262, Le @job_id ('4A6A6F00-D9BF-4C58-A22D-2376CD9D1A14') spécifié n'existe pas. [SQLSTATE 42000] (ConnExecuteCachableOp)
rm
New Member
New Member

--
19 Mar 2010 04:09 AM
Does it have latest service pack?
You are not authorized to post a reply.

Acceptable Use Policy