Return
-
Title
SQL Agent Job Not Showing correctly -
Description
Spotlight is showing that a SQL agent job has been running for several days when it has finished (twice) in few minutes during that time.
Restarting the diagnostic server didn't the issue, it was still showing up.
-
Cause
Found user msdb.dbo.sp_help_jobactivity
has large last run job time store.
-
Resolution
Dropping and recreating the maintenance plans solves the problem.