I think you may have dropped a few characters from the end of your sample 'az containerapp job create' command.
az containerapp job create \
--name "$JOB_NAME"\
--resource-group "$RESOURCE_GROUP"\
--environment "$ENVIRONMENT"\
--trigger-type "Event"\
--replica-timeout "1800"\
--replica-retry-limit "1"\
--replica-completion-count "1"\
--parallelism "1"\
--min-executions "0"\
--max-executions "10"\
--polling-interval "60"\
--scale-rule-name "queue"\
--scale-rule-type "azure-servicebus"\
--scale-rule-metadata "queueName=xxxxx" "namespace=xxxxxx" "messageCount=1"\
--scale-rule-auth "connection=connection-string-secret"\
--image "$CONTAINER_REGISTRY_NAME.azurecr.io/$CONTAINER_IMAGE_NAME"\
--cpu "0.5"\
--memory "1Gi"\
--secrets "connection-string-secret=$QUEUE_CONNECTION_STRING"\
--registry-server "$CONTAINER_REGISTRY_NAME.azurecr.io"\
--env-vars "AZURE_STORAGE_QUEUE_NAME=$QUEUE_NAME" "AZURE_SERVICE_BUS_CONNECTION_STRING=secretref:connection-string-secret"