>>>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
I certainly hope so! It would make me very nervous to have users wandering around in SSMS. Heck, I've worked places where the DBAs were reluctant to give application developers access.