According to your description, I guess the reason why you faced the error is your SAS token doesn't have enough permission to CRUD the blob.
The SAS token must be the blob container SAS token not the blob SAS token.
Besides, if you set the the azure web app's diagnostics logs Application Logging feature, it will auto generate a SAS token in your web app's appsetting.
More details, you could refer to below image:
Set the storage account in the diagnostics logs.
Then it will auto set the appsetting:
Update:
Failed to validate Microsoft Azure WebJobs SDK Dashboard connection string. The Microsoft Azure Storage account connection string is not formatted correctly.
If you upload a webjobs to your web app, the web jobs need two appsetting. One is the Dashboard connection string, another one is the AzureWebJobsStorage.
Both of these two setting need the storage connection string not the storage SAS.
You could find the storage connection string as below image shows:
1.Open the storage access key feature.
2.Copy the connection string:
3.Replace the connection string in the web app appsetting.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…