Has this ever worked or is this the first time you've tried to get this working?
If this has worked in the past, what has changed recently?
If this has never worked before, have you investigated to ensure the table indicated in the error message exists and that the Run As User account has proper permissions to the datasource?
Thanks for the response. We have restarted the SAS server which fixed the issue. Now the Jobs running successfully.