Event ID: 208 - Job Engine

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date:  7/31/2009
Time:  4:21:49 AM
User:  N/A
Computer: MXPSV-EFOX-DCDB
Description:
SQL Server Scheduled Job 'MfAssyComponentSaveJob' (0xF132F77A625F064AB4835767670E6CB0) - Status: Failed - Invoked on: 2009-07-31 04:20:07 - Message: The job failed.  The Job was invoked by Schedule 22 (11).  The last step to run was step 1 (eFoxSFCSaveAssyComponentJobs).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. 

 

查看Job view history log记录 ： 

-------------

Executed as user: MXPSV-EFOX-DCDB\it.service.    Violation of PRIMARY KEY constraint 'PK_mfAssyComponent'. Cannot insert duplicate key in object 'mfAssyComponent'. [SQLSTATE 23000] (Error 2627)  Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0. [SQLSTATE 25000] (Error 266)  Insert  into  mfAssyComponent  Error! [SQLSTATE 42000] (Error 99999)  DPDGVH1  Save to table mfAssyComponent Error. [SQLSTATE 42000] (Error 99999)  The statement has been terminated. [SQLSTATE 01000] (Error 3621).  The step failed. 

估计是PK重复值的问题 。

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-611016/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-611016/