Installing job exe files on the webserver
Symptoms
We are installing the application in a SQL environment. We no longer can install exe files on database server. Therefore, the exe files such as CPEffectiveDates.exe, CPGuestLicenses.exe, WorkflowEscalation.exe called from SQL Agent jobs need to be installed on Web server(s).
What is the process for calling the EXE files from SQL Agent jobs?
Resolution
1. Create a shared folder on web server and place all exe\dll files into shared folder;
2. Configure SQL Agent service account to access the web shared folder;
3. Modify all EXE jobs to point to the shared folder path.