>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/
If it's not broken, fix it until it is.
My Blog