linux job id,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 .

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