>>>Hi
>>>
>>>I've got some Jobs that run stored procedures to produce some reports.
>>>
>>>These jobs are scheduled but sometimes users want to be able to trigger there running themselves.
>>>
>>>has anyone got any idea how I can give users the ability to start jobs in SQL Server.
>>>
>>>Thanks
>>>
>>>Nick
>>
>>
http://www.sqlusa.com/bestpractices2005/startjobfromstoredproc/>
>No thanks Naomi
>
>I want users to be able to trigger a job from outside the SQL Management Studio.
>
>Thanks
The only other way I can think of is to create a small app / PowerShell script having the above mentioned command in it and they will be able to run it. Also, it may be a bit complex thing in regards to permissions.
If it's not broken, fix it until it is.
My Blog