Start a SQL Job by an User

Posted on 2011-02-15
Medium Priority
Last Modified: 2012-05-11
Hi Experts.

I need your help! I have some export jobs in my SQL Server 2008.
Those jobs have to be started by an user.

As soon as the user has finished his job (entering data) the export should start by an interaction of the user.

I tried to use a batch file which was startet by the user, but since they do not have access to the SQL Server, they cant start the job.

Any ideas how i could handle this export?

Question by:StevetheBeef
LVL 28

Accepted Solution

Ryan McCauley earned 2000 total points
ID: 34897803
You can grant them rights to execute SQL Agent Jobs:


However, it appears that "Execute" is a global right, and you can't give them the rights to execute just a single job. Alternatively, you could create a Stored Procudure that executes this job (using MSDB..sp_start_job) and grant them rights to execute that. For more details about doing that, check out this Microsoft article:

LVL 27

Expert Comment

ID: 35225204
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question