The job did kick off but it failed immediately. I made a quick change to the procedure to bypass the failed query to allow the refresh to continue. I've kicked off the process and the refresh has started again.
I suspect there might be something in the latest patch of SQL Server that impacted this, as we just pushed the latest patch this week, but that's a ...
The ClosedDate is only set if the post is currently closed.
Assuming that a post is closed just because it has a history event for being closed is an incorrect assumption. That only means it has been closed before, but could have been reopened since then. Have you checked those posts to see if they have a Reopen post history event (PostHistoryTypeId = 11)? A ...
There will be! Later this week, Stack Overflow will start tracking which answers are viewed on posts, and this data can be used to determine how many answers people tend to read (on Stack Overflow, at least). "there are no immediate plans to display this data on the site, make it available in SEDE, or expose it via the API", but there will likely ...
These are posts that have been closed and reopened.
They were closed at one time so they have an entry in the PostHistory table.
They are not closed now so their close date is null.
You can see this in the post timeline e.g.
Which window to choose?
and so on.