I'm unable to run an executable in the Sql Server Agent.
For example if I just wanted to open Notepad from the Sql server Agent, I did the following:
Create Job Step -> Change Type to Operating System (CmdExec) -> Command is C:\Windows\System32\Notepad.exe.
But the job doesn't do anything it just keeps executing with no results...
What am I doing wrong, I tried a couple of commands. I even created an SSIS package to open it...the package opens the application correctly from SSIS, but once the package is in a job it doesn't open.