Job "In Progress" message

  • I have a job that takes a database backup. There are 4 steps in the job and server was restarted when the 4th step was in progress. The last step copies the .bak file to a different server (vbscript).

    When I look up the history of the job through SSMS, it says the job is "in progress" (message column). Refreshing the job history view, refreshes the date column to the current system date/time. I have restarted Agent on the server and it still shows the job is in progress. Stopping the job gave a error that the job is not running.

    How can I fix the job history for this job ?

  • I added entries in the sysjobhistory table for the job outcome and fixed the issue.

    Thanks for looking.

     

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

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