python script not running as a SQL Server scheduled job

RobertHu — Wed, 12 Dec 2012 18:02:11 GMT

Python 2.7
ArcGIS 10.1 (sp1)
ArcSDE 10.1 (sp1)
SQL Server 2008 R2 Standard (sp2)
Windows Server 2008 R2 Standard (sp1)

Run a batch file, which calls a python script, as SQL Server scheduled job, if the python script includes "import arcpy" statement, the script will fail without leaving any error message. The script works fine without the "import arcpy" statement. Tried samething as a system scheduled task, the results are same.

While running the batch file from command line, it works fine with or without the "import arcpy" statement.

Anyone ever experienced same thing, and have a clue?

Thanks in advanced!

Re: python script not running as a SQL Server scheduled job

RashanWalker — Thu, 13 Dec 2012 22:55:22 GMT

Here are the instructions to run a Python script as a scheduled task in SQL Server:
1. Open SQL Server Management Studio
2. Select SQL Server Agent
3. Right-click on "Jobs" and select "New Job"
4. On the "Steps" page, select "New" (At the bottom of the screen)
5. Select "Operating System (CmdExec)" for the "Type"

-- Sample Python script (C:\Python26\HELLO_931.py)
import arcpy
print 'HELLO'

-- Type in the following information in the "Command" window
cd C:\Python26
HELLO_931.py

topic Re: python script not running as a SQL Server scheduled job in Geoprocessing Questions

python script not running as a SQL Server scheduled job

Re: python script not running as a SQL Server scheduled job