I am having an issue with this as well.
I just loaded ArcGIS Desktop 10.1 this past weekend.
The python scripts will not run from a scheduled SQL Server job using CmdExec or PowerShell, or even when packaged into an integration service (SSIS).
It will, however, run perfectly when called directly from command line, a PowerShell session, or even a PowerShell session that was started using the SQL Server Management Studio's "Start Powershell" command. It also runs from with a python window in ArcMap 10.1.
I can also run it from the Windows Task Scheduler with no problems.
I receive the following errors when the scheduled job in SQL Server executes:
[INDENT]Faulting application python.exe, version 0.0.0.0, time stamp 0x4df4ba7c, faulting module AfCore_libFNP.dll_unloaded, version 0.0.0.0, time stamp 0x4f920360, exception code 0xc0000005, fault offset 0x0de94eb4, process id 0xa38, application start time 0x01ce728082fce90c.
Faulting application python.exe, version 0.0.0.0, time stamp 0x4df4ba7c, faulting module unknown, version 0.0.0.0, time stamp 0x00000000, exception code 0xc0000005, fault offset 0x0dc8dc80, process id 0x%9, application start time 0x%10.[/INDENT]
Does anyone have any ideas?