I am developing Win C# application using VS 2019 and is converted into EXE application.
EXE Name : EmpMod.EXE
I am planning to scheduling this EXE into SQL server. I am facing below issue in server.
EXE is not running and it is showing error. The error is showing the could not load the file and path not found.
Because, EXE is build in local system and in server referring the build local path and not referring server path.
So, every time i am build the application as EXE again @ server, then i am in a position to use it . then only it's referring the server path.
i am trying to put this EXE into SQL Job scheduler.
Here the problem is, the Execution path always referring the application in Bin\Debug folder only.
Ex : cmd /C c:\ANAProject\SourceCode\EmpModule\bin\Debug\EmpMod
if i use some other folder, this is not working and showing the in-appropriate path error or some other error
If i manually run from the job scheduler and referring path is bin\debug, my exe working.
If i automatically schedule the job then i am facing the below error.
Also, the below error is showing the Jobs "View History"
Executed as user: SERVERXMN\SYSTEM. The filename, directory name, or volume label syntax is incorrect. Process
This kind of problem will be happening only in VS 2019 build application.
The same if i develop the application in VS 2010 or VS 2013, i don't get any issue at all in the server.
How do we solve the above problem...?
How to solve the referring EXE any path instead of referring from bin\debug.
How to use build EXE in server, which has been developed in local system , the same can be use in server without any newly build in
This is applicable both in Win/Web application and what are all developed in VS 2019.
pls. guide us, how to solve this type of issues.