Question

Is there a provision of on failure ability in puppet

Answer 1

Not a built-in one, no. 

They do log failures, of course. Or I guess the PE version might have something like that , may be.

When run in --onetime mode, the agent's exit code conveys its success or failure, but you'd still have to analyze the log / console output to ascertain the nature of any failure. 

To use this for scheduled runs you would want to use an external scheduler such as cron to run the agent, rather than letting it run as a daemon itself.