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
- SQL Server job output to Azure blob storage
- Data Truncation issue while importing excel from Azure Blob storage to Sql Server
- Copy image field data from SQL Server to Azure Blob Storage as blob blocks
- "Error while decoding the storage key" when backing up SQL Server database to Azure Blob using Shared Access Signature
- How to create the file in azure storage blob using SQL Server
- Android App Offline Sync to Azure SQL Server and Blob Storage
- Can Microsoft Azure SQL Server utilize FileTable / Blob Storage?
- Azure VM SQL Server Tempdb on Temporary Storage
- Azure SQL Server Error : The elastic pool has reached its storage limit. The storage usage for the elastic pool cannot exceed (204800)
- read file from Azure Blob Storage into Azure SQL Database
- Load CSV from Blob to Azure SQL Server - Referenced external data source not found
- SQL Server Express database size / BLOB storage
- What is the better and faster way to save and get files Azure BLOB storage or SQL SERVER?
- List of blobs in Azure Storage from SQL Server
- SQLSTATE 01000 in SQL Server job output
- SSMS Back-up and Restore SQL Database to Blob Stopped Working After Switch to Azure Storage Gen2 with AD DS
- Multiple storage of images and BLOB files in SQL Server
- Polybase: Can't connect to Azure Blob from SQL Server
- Semaphore timeout error while creating a Sql backup in Azure blob storage since 3 days ago
- Cannot open backup device - SQL Server on-premise backup database to Azure storage
- How to load json from Azure Blob to SQL Server using SSIS?
- Azure SQL blob storage select
- Restore SQL Backup from Azure Blob Storage
- SQL Server Output Clause into a scalar variable
- How to get export output in "real" CSV format in SQL Server Management Studio?
- How to return the output of stored procedure into a variable in sql server
- Get Table and Index storage size in sql server
- Will a SQL Server Job skip a scheduled run if it is already running?
- Restoring SQL Server backup to Azure SQL Database
- SQL Server Agent Job - Exists then Drop?
More questions with similar tag
- reparenting hierarchyid values
- TSQL UPDATE based on MAX (Date) in other table
- Thoughts on highest performance method regarding LINQ
- SQL Server: create database diagram by query
- How to sum the values of one colum except negative numbers or null in SQL
- Index seek changes to index scan on change of value in where clause
- SQL Query for getting nth Weekday date between two dates
- Full Outer Join and Null Values: The # of successful medical attentions per Year pear Doctor
- What's the best way to diff two database backup files with MS Sql Server 2005?
- how to concatenate three strings first two characters automatically in sql server
- SQL CLR Trigger, How to make an assembly trusted due to transparent code call critical code?
- C# & SQL Server : ExecuteNonQuery returning -1, when UPDATE works?
- Ordering by the order of key value
- is it possible execute a perl script with admin rights or as a specific user?
- Understanding documentation of "Row-Overflow Data Exceeding 8 KB"
- Merge two or more rows in SQL Server 2000
- sql query to split day part from time period
- How do you change the DURABILITY option on an existing memory-optimized table in SQL Server 2016?
- SQL Server For JSON Path dynamic column name
- How to delete the last record
- Less repetition in where-clauses when querying many columns
- SQL Server - joining 4 fast queries gives me one slow query
- Bulk insert in parent and child table using sp_xml_preparedocument
- How do I import an Excel spreadsheet into SQL Server 2008R2 database?
- SQL query results Need to Return all records in WHERE clause even duplicates
- How should I add a URL into my SQL Case Statement?
- Auto-generated static field in F# class/module prevents creation of SQL CLR function
- Declared variable behaving differently to hard coded string
- Assign null if subquery retrieves multiple records. How can it be done?
- how to copy default constraints of columns in temp table?
Source:
stackoverflow.com