Msg 15121, Level 16, State 21, Procedure xp_cmdshell, Line 1
An error occurred during the execution of xp_cmdshell.
A call to 'CreateProcess' failed with error code: '1450'.
Today one of my sql job which collects All disk space details for server fails with above error.
From error its very much clear that xp_cmdshell is failing with error code 1450. As this is a weekly job i was sure there is no case of any access issue.
On researching i found
Error 1450 = "Failed to write to virtual disk. System error= [Insufficient system resources exist to complete the requested service. (1450)]"
I also manually run script and got same error , which means its resource issue.
So i did RDP on server and found CPU and memory was normal but there is no space on C: drive. Its showing 0 MB free.
So we created some space on C: drive and again job starts working fine.
Note: If you get error "failed with error code: '5'" ; Its a access issue. Give access to user running xp_cmdshell on folder.