Error 22022: SQLServerAgent Error:

• christian boisvert

  Valued Member

  Points: 63

  More actions

  April 3, 2004 at 12:03 am

  #84875

  I got the Error 22022: SQLServerAgent Error: job xxxxxxxxxxx(too long to write) does not exist in the job cache when i start the merge agents. Somebody can tell me what i have done wrong or what does it means ?

  N.B. both sql server are log with the same account and password.

  Thanks.

• Keiths123

  SSCommitted

  Points: 1789

  More actions

  April 5, 2004 at 1:53 am

  #501722

  Does the error message show a job name or a long string of characters that is the ID of the job? If it is the latter then it may be that you have made changes to the job since it was scheduled.

  When you schedule a job using Enterprise Manager it uses the ID of the job to identify it. If you then make a change to the job and save it, even without changing the name of the job, it will assign a new ID to that job.

  Try either rescheduling the job or changing the schedule to use the job name instead of the ID.