I imagine the president receives a list of potential targets on a regular basis and for whatever reason, this one resonated this time. They had his location - probably a rare intelligence coup - and Trump was advised that it was now or never if he wanted to make a huge statement following the rocket attacks earlier in the week.

I would imagine that the intelligence agencies frequently know where targets are, but only rarely carry out a strike.