How to trigger a SQL Agent Job from a client PC
- by Preet Sangha
I have SQL Agent job that is automated that a non SQL Admin user may need to occasionaly run. I know I can trigger a SQL Agent Job via sp_execute_job.
Can anyone tell me where to find what I need installed on a (Non SQL Server box) client PC in order to run one of - SQLCmd, OSQL or ISQL - commands please, so I can execute the above SQL?
Or is there are simpler way perhaps with out calling TSQL or without installing any SQL client tools.