We are using bigquery schedule query.
The following errors are occurring
An error is occurring in a schedule query created by a member who participated in the past.
The error started to occur after deleting the member.
(If possible, we would like to avoid having past members rejoin the project.)
What should we do to resolve the error?
Access Denied: Project xxxxx: User does not have bigquery.jobs.create permission in project xxxxx.; JobID: xxxxxxx
The bigquery.jobs.create permission is present in both the bigquery.user and bigquery.admin roles, so either should be sufficient.
Please verify that the project (xxxx) in which the task is being executed (user xxxx@gmail.com), which may not be the same as the project containing the data itself, has those rights.
As an alternative solution, you need roles/bigquery.jobUser role at project level.
“Provides permissions to run jobs, including queries, within the project,” according to the BigQuery Job User role.
You can review more in IAM basic and predefined roles preferences documentation.
Additionally, here is a similar question in StackOverflow with a solution you can check.