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 .
查看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重复值的问题 。