Yes it got solved..in my case odata was not installed on the machine from whic iam running the sql agent job.once i had installed it ran fine