I have never had to sign one, but I know what they are.
If you get a DUI...or if you cop to a drug or alcohol problem and take a leave of absence in order to undergo rehab...a condition of returning to work is that you sign a "last chance" agreement to remain drug and alcohol free. Violation of said agreement is grounds for immediate termination.