Sorry for not posting the error. Below it is:

"Failed:(100) An exception occurred while executing a Transact-SQL statement or batch."

This is the error for both the jobs. And I have tested...