How does the sqlserver "agent_job_failure" checkpoint work?