No history file records writing.

• TJAYWHY

  SSC Enthusiast

  Points: 147

  More actions

  July 16, 2015 at 11:29 am

  #302367

  Hello All,

  This is pertaining to SQL Server 2012 Enterprise.

  Jobs that run are running are completing but writing nothing to the job history. In the error logs I am getting:

  [298] SQLServer Error: 547, The DELETE statement conflicted with the REFERENCE constraint "FK_syscollector_collection_sets_upload_sysjobs". The conflict occurred in database "msdb", table "dbo.syscollector_collection_sets_internal", column 'upload_job_id'. [SQLSTATE 23000] (ConnExecuteCachableOp)

  I also noticed that if I manually start a job, the window will always show that the step is "processing" and never complete, even though the job had finished long ago.

  We renamed the server a couple weeks ago, other than that no changes. Not sure if this problem occurred since the change of server name.

  Any help is appreciated

  Thanks