You need to set up a proxy account in SQL Server that has user rights to the directory where the .cmd file is located. Look for documentation in books online...