Check Geoprocessing Service SDE Connection Status

Anonymous User — Thu, 13 Aug 2015 15:35:24 GMT

In a nutshell: Is there a way to check if a geoprocessing service has been disconnected from an SDE, and then reconnect it if so?

I am trying to work around this bug: NIM072515 - 'Provide option to enable schema locking property for a geoprocessing service.'

I have a geoprocessing service published to the server (Data Extract) which puts a lock on the SDEs from which data is extracted (no option to disable schema locking like there is for a map service). This schema lock means that I cannot add/delete fields and change other 'schema' aspects of a feature without right-clicking the SDE in ArcCatalog --> Administration --> Administer Geodatabase and deleting the server connections causing the schema lock from the geoprocessing service.

However when I do that, the Data Extract task runs from the web map but returns empty, no data. I believe because it was disconnected from the SDE.

What I would like to do in my new data download script using arcpy is:

Before download, check if the service has been disconnected from the SDE
Reconnect to SDE when necessary

Thanks for any tips!

topic Check Geoprocessing Service SDE Connection Status in Python Questions

Check Geoprocessing Service SDE Connection Status