The specified @name ('xxxxxxxxx') already exists. [SQLSTATE 42000] (Error 14261). The step failed.

• Chowdary's

  SSCrazy

  Points: 2978

  More actions

  August 7, 2014 at 12:57 am

  #297628

  Hi All,

  We are having 2008 SQL server,

  We have created a job with the name xxxxxxx,at the first time job succeeded, When am trying to start the job next time it is throwing some msg like the Following

  The specified @name ('xxxxxxxxxxx') already exists. [SQLSTATE 42000] (Error 14261). The step failed..

  So i have remove that Job and created a new job still same problem am getting when am trying for the next time.

  Can anyone explain me about this issue..

  PFA..

  Regards

  Chowdary.....

  Regards
  Chowdary...

• Ant-Green

  SSC Guru

  Points: 113499

  More actions

  August 7, 2014 at 1:14 am

  #1735853

  One of the job steps isnt trying to recreate the job is it?

  Probably calling a SP which creates it then runs it.

• VastSQL

  SSC-Dedicated

  Points: 36096

  More actions

  August 7, 2014 at 2:42 am

  #1735875

  Can you post the code you used here?