Job completion date?

Noticed this today, a bunch of jobs were marked as completed today, the date on the Job closing window shows the correct date (today), but when I query the same job in SQL (SSMS), the JobCompleteDate is null.

Any reason why? If I uncomplete, complete then save the job in Job Closing it fixes the issue

You might try data fix workbench to fix multi row, then monitor whether it occur again. Recommend backup db and restore to test environment. Then run fix workbench

1 Like