The senior agent was shot in a car park in broad daylight on Thursday morning, CCTV shows.