'use python inside SQL Server and scheduled jobs to generate excel files

I am using SQL Server 2019. I have several users who need some listings in the form of Excel files, delivered into a shared directory, and updated periodically (monthly reports ...).

So I would like to use Scheduled Jobs, python run via sp_execute_external_script (python running inside SQL Server), python modules to produce Excel content, and what it takes to write out a file.

Is this possible ? Can these bricks work together ? Are the necessary python modules easy to import into the SQL Server python instance ?

pythonsql-serverexcelsql-server-2019


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions