Is that the message from job history?

You should ensure the job creates a log, and examine that. The insert might fail, but that won'd necessarily fail the job. Can you ensure you make it clear what code is in the job?