reported "Incorrect syntax near '133'. [SQLSTATE 42000] (Error 102)." when job executed

• wangshyun

  SSC Enthusiast

  Points: 111

  More actions

  January 29, 2013 at 3:12 am

  #149687

  Dear all,

  The stored procedure can run successfully in sql query analyse, but the job which calls the procedure fails. The error message is:

  LogJob History (WapGw_FiveMinute_Report)

  Step ID5

  ServerBMI-LTE-OAM1

  Job NameWapGw_FiveMinute_Report

  Step Namep_log_realtime_Process

  Duration00:00:00

  Sql Severity15

  Sql Message ID102

  Operator Emailed

  Operator Net sent

  Operator Paged

  Retries Attempted0

  Message

  Executed as user: NT AUTHORITY\SYSTEM. Incorrect syntax near '133'. [SQLSTATE 42000] (Error 102). The step failed.

  Please help me. Tks.