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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » reported "Incorrect syntax near '133'....

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

Rate Topic

Display Mode

Topic Options

Author

Message

wangshyun

Posted Tuesday, January 29, 2013 3:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 3:07 AM
Points: 1, Visits: 0

Dear all,

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

Log Job History (WapGw_FiveMinute_Report)

Step ID 5
Server BMI-LTE-OAM1
Job Name WapGw_FiveMinute_Report
Step Name p_log_realtime_Process
Duration 00:00:00
Sql Severity 15
Sql Message ID 102
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

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

Please help me. Tks.

Post #1412854

« Prev Topic | Next Topic »

Permissions