?
Solved

Start a SQL Job by an User

Posted on 2011-02-15
3
Medium Priority
?
460 Views
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?

Thanks!
0
Comment
Question by:StevetheBeef
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 28

Accepted Solution

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

http://msdn.microsoft.com/en-us/library/ms190926.aspx

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:

http://msdn.microsoft.com/en-us/library/ms186757.aspx
0
 
LVL 27

Expert Comment

by:Tolomir
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.
0

Featured Post

Does Powershell have you tied up in knots?

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.

If you are experiencing a similar issue, please ask a related question

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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 …
Suggested Courses

752 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