Please copy the command from the job, paste it into a SSMS query window, run it, and tell me what happens.

John