I assume that you are using sp_start_job to start the Agent job?
If so, the fact that it returns 'success' means only that the job was started successfully. It does not mean that the job completed successfully.
sp_start_job starts a separate async process to execute the job.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.