Should be in the Job Task history...
...accessible from Enterprise Manager (or Management Studio, or whatever they happen to be calling it this week). My suspicion would be that the job might have been set up for an account that doesn't have permission to drop tables.