score:0

I'm agree with @ Rishav Singh, we can not redirect SQL Server Agent Job output directly to Azure blob storage.

Any other ideas, you can using AzCopy to upload output file to Azure blob :

azcopy copy '<local-directory-path>' 'https://<storage-account-name>.<blob or dfs>.core.windows.net/<container-name>' --recursive 

You can run this AzCopy command with xp_cmdshell (Transact-SQL) in SSMS:

EXEC xp_cmdshell 'azcopy copy '<local-directory-path>' 'https://<storage-account-name>.<blob or dfs>.core.windows.net/<container-name>' --recursive' 

Ref: HOW TO: EXECUTE DOS COMMANDS FROM T-SQL

Hope this helps.


More questions

More questions with similar tag