Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer
    
Thank you for pointing out the security I was aware of this. Please see my edit - I know I can execute this SP, what I'm asking is what I need installed on the client's PC in order to issue the command. –  Preet Sangha Nov 24 '11 at 6:07
    
The only thing that needs to be installed on the users PC is something which will allow them to run the needed T/SQL statement. You can install SQL Server Management Studio, sqlcmd, osql, isql, some app that you have written. If you take a few minutes it could be triggered by Word, Excel, Access, etc. as well. –  mrdenny Nov 24 '11 at 15:25
    
Apologies - my fault I'm not being clear. I was looking for the minimum I need installed on the client's PC. I know I can use use any program that comes from the SQL Server client but I was wondering what the minimum library set I need. For example does windows have enough in it to allow OSQL.exe to run with out any other dependencies being installed? –  Preet Sangha Nov 25 '11 at 9:02
    
Yes, Windows includes the SQL native client and the SQL Server Driver which is enough to make a connection. I'm not sure if you can just copy osql.exe onto a computer and use it or not. –  mrdenny Nov 25 '11 at 18:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.