SQL 2014 Standard - All SQL agent jobs disabled after patch

  • We have a SQL server 2014 (with SSRS) and over the weekend the list of patches below got installed around 1AM.

    KB5029312

    KB5028970

    KB5028957

    KB5029368

    The following morning it was noticed that no jobs ran and when we checked, EVERY single SQL agent job had a red x and were all disabled.

    I have never seen this before. Has anyone else encountered this? Any idea on the cause?

    Thanks

    • This topic was modified 1 year, 1 month ago by  Warren Peace.
    • This topic was modified 1 year, 1 month ago by  Warren Peace.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • I've never seen anything like that from a CU before.  What happens when you re-enable the jobs?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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