Sql Jobs CommandText Length

• tcsreenivas

  Newbie

  Points: 5

  More actions

  December 27, 2006 at 11:24 pm

  #116741

  I Created a Sqljob in that Job given command Length more 3200 characters then run that job,but it will gives error as command length not more than 3200 characters, but i have very long command (ie;script file)

  Is there any solution for this problem

   

   

   

   

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  December 29, 2006 at 7:12 am

  #680477

  please write it as a stored procedure and call it from the job