I'm trying to setup a SQL Server agent job of type CmdExec
for running an executable inside %programdata%\my company folder
.
If I use %programdata%\my company\myexec.exe
, the job fails with error:because it apparently can't find the file.
it can't find the file.
But it works with the absolute path as follows:
C:\ProgramData\my company\myexec.exe
Anybody knows a way toHow can I run the job successfully using the special folder alias?