I have a C# console application that I need to run on a scheduled basis. The app also have a number of paramters (ie Start Date, End Date, 'Summary' or 'Detail') etc.
I can run the app from the cmd prompt no problem.
However, when I try to add this as a scheduled job, it fails.
First it gave me security issues, so I created a credential and proxy, but now it just hangs/runs without ending...
Can anyone confirm that console apps can run as SQL jobs?
If not, what options would you suggest?
If this should work, can anyone offer some suggestions on how to configure this?
I was trying to test so other apps, but they seem to have similar results.
Thanks in advance.