Post reply

SQL Server Agent - No history recs being written

  • July 16, 2015 at 11:36 am

    #300316

    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 when the job runs:

    [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

  • July 21, 2015 at 8:52 am

    #1813874

    Right click SQL agent

    Properties

    History click remove agent history and set it to a suitable time.

    You may have 'limit size of job history log' set to a low figure

  • July 21, 2015 at 8:59 am

    #1813875

    Thanks for the reply.

    It is not an issue of too much history. The history file is empty. It appeared SQLServer was trying to run data collection job during the job run; which I had removed and should not have been happening. This failure apparently caused the history update to not occur. I did a repair on the installation and that fixed the problem.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply