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?
I have no issue with what I need to execute in the database, rather the minimum of what I need on the client PC.
Or is there are simpler way perhaps with out calling TSQL or without installing any SQL client tools.
You'll need something that can log into the database. Then either you can run sp_execute_job from the msdb database. If the users don't have the rights to do that themselves, you can create a user which has those rights and have a stored procedure that uses execute as and then starts the job.