I'm a C-130 guy. We only get issued "no-go" pills, almost never a "go" pill. Since we lack the ability to midair refuel, we're pretty much limited to 9-12 hours of flight time anyway. I wasn't even required to ground test the "go" pill.
In the desert our schedules flip flop every 72 hours it seems. You'll fly a night, a day, a night, a day, and on and on. Its havoc on your sleep schedule, so they'll issue you either Ambien, Restoril, or Sonata, and each has their own "use x hours prior to flight" rules. I was a fan of Restoril- knocked me the hell out, and no hangover when I got up.
You'll never get no-go pills in the CONUS. And any use of the leftover no-go pills once you get home from the desert is STRICTLY forbidden. There have been quite a few pee-pee schwackings from that.
Hope this helps.