Call Python file from within SQL Server

Question

I have Python script in a file names "C:\Python\HL.py"

In this Python script there are predictive models and updates to some tables in my SQL database.

I want to call this file as a SQL Job

How can I achieve that?

This question is different

How to Execute Python Script as Administrator in SQL Server Agent Job

the provided solutions were through proxy command and scripting in the SQL.

I just want to call a Python .py file from within SQL Server Job

refer to documentation on SQL Agent learn.microsoft.com/en-us/sql/ssms/agent/… — Squirrel
– Squirrel, Commented Sep 30, 2019 at 1:39
Possible duplicate of How to Execute Python Script as Administrator in SQL Server Agent Job — Piotr Palka
– Piotr Palka, Commented Sep 30, 2019 at 2:24

asmgx · Accepted Answer · 2019-09-30 03:07:57Z

4

When you creating a SQL Server Agent job step, you should select:
1. Step type: Operating system (CmdExec)
2. Run as: here you can use Agent service account (less secure) or better option is to create dedicated service account and register it as a proxy account. If you decide to use Agent service account, you will be granting Server Admin privileges to python scripts.
3. In command type: "C:\Windows\System32\cmd.exe" "python C:\Python\HL.py"

edited Sep 30, 2019 at 3:07

asmgx

8,14819 gold badges102 silver badges184 bronze badges

answered Sep 30, 2019 at 2:27

Piotr Palka

3,2351 gold badge12 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ed Bangga · Accepted Answer · 2019-09-30 01:24:50Z

2

Create a job step with this script

DECLARE @CMDSQL VARCHAR(1000)


SET @CMDSQL = 'cmd.exe py "C:\Python\HL.py" '
Exec master..xp_cmdshell @CMDSQL

But make sure your xp_cmdshell is enabled.

sp_configure 'show advanced options', '1'
RECONFIGURE
-- this enables xp_cmdshell
sp_configure 'xp_cmdshell', '1' 
RECONFIGURE

answered Sep 30, 2019 at 1:24

Ed Bangga

13k4 gold badges18 silver badges31 bronze badges

3 Comments

Piotr Palka Over a year ago

Using SQL Agent step is correct, but I disagree with using SQL Server service account, step type "TSQL" and xp_cmdshell.

asmgx Over a year ago

Ed Bangga Over a year ago

have you set your python path?

Collectives™ on Stack Overflow

Call Python file from within SQL Server

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related