Sqlcmd -E -S <servername> -Q"exec stored-procedure-name" Put it in a bat/cmd file with a shortcut on their desktop. They'll need the tools installed locally, or use psexec to run it remotely.
Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com -----Original Message----- From: Nigel Parker [mailto:[email protected]] Sent: Thursday, February 25, 2010 6:16 AM To: NT System Admin Issues Subject: SQL Server I need to give a "user" the ability to run 1 job for one of our sql servers The job needs to be run after a manual process that takes different amounts of time to complete, and MUST be run immediately after all the manual processes Unfortunately I cant change this I tried creating a custom MMC for just this task but sadly Failed Is it possible to assign or create a MMC so the user can see just 1 job in the management/job list And then be able to run it Sorry not to hot on SQL server and I suppose this is the wrong place to post the question, but any help is welcome especially if its Step by Step :-) Thanks Nigel Parker ------------------- Systems Engineer Ultraframe (UK) Ltd Tel: 01200 452329 Fax: 01200 452201 Web: <www.ultraframe.com> Email: <mailto:[email protected]> ------------------- Please consider the environment before printing this e-mail ------------------- Ultraframe design and manufacture innovative and quality conservatory solutions to suit all styles, all applications, all consumers and every price point. By demonstrating our company values of innovation, integrity, total quality, premium service and customer first, we will to continue to build our position as UK market leader. For more information visit our website: <www.ultraframe.co.uk> The statements and opinions expressed in this email are my own and may not represent those of Ultraframe (UK) Ltd. This email is subject to copyright and the information contained in it is confidential and may be legally privileged. It is intended only for the named recipient(s). Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
