Home Forums SQL Server 2012 SQL Server 2012 - T-SQL SQL Agent Job Shows Running for Days, but Not Really Running RE: SQL Agent Job Shows Running for Days, but Not Really Running

  • September 22, 2016 at 6:35 am

    #1902437

    jerry-621596 (9/15/2016)

    I tried your script and get and error saying the request to stop the job was refused because the job is not currently running.

    Seems like the mystery runs deeper than I thought.

    I hate making this suggestion. I really do. But sometimes it's the only fix to phantom jobs.

    You may have to restart SQL Server Agent service.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.