IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / sp_start_job may do the trick
Post #101,768
by ChrisR
5/13/03 11:14:52 PM
Reply
New sp_start_job may do the trick
EXEC sp_start_job @job_name = 'Test Task'

But I'm not sure about how user privileges limit the ability to invoke the procedure.
Post #101,770
by broomberg
5/13/03 11:30:19 PM
Reply
New Thanks
I'll try it tomorrow.
I assume I would have to put this in some type of sql script.

Guess I can now use SQSH!
Post #101,777
by ChrisR
5/14/03 1:12:24 AM
Reply
New Probably the best way...
...is to wrap it in a stored procedure created from the administrator account and grant execute privilige to that stored procedure to the various accounts you want. The accounts won't be able to start the Task directly, but they can call a stored proc that will do the chore:

CREATE PROC RunTask As
EXEC msdb..sp_start_job @job_name = 'Test Task'
GO

GRANT EXECUTE ON RunTask TO MyMinions
GO

-- MyMinions then run
EXEC RunTask
     SQL/Server / SQLAGENT / Running by hand - (broomberg) - (12) - May 13, 2003, 04:39:33 PM EDT
         One possible hint - (kmself) - (8) - May 13, 2003, 10:39:11 PM EDT
             Don't see how it applies - (broomberg) - May 13, 2003, 11:27:42 PM EDT
             Works - (broomberg) - (6) - May 14, 2003, 10:09:07 AM EDT
                 OK, too - (kmself) - (5) - May 14, 2003, 07:05:20 PM EDT
                     OT: how is DOMAIN\\USER kind of login supported in SAMBA - (Arkadiy) - (4) - May 15, 2003, 05:30:34 PM EDT
                         RTFM - (deSitter) - (3) - May 15, 2003, 10:16:03 PM EDT
                             Consider winbind. -NT - (pwhysall) - May 16, 2003, 02:55:36 AM EDT
                             Client. Client. Client. Damn it. -NT - (Arkadiy) - (1) - May 16, 2003, 12:56:46 PM EDT
                                 As Petah said... - (tseliot) - May 16, 2003, 01:04:58 PM EDT
         sp_start_job may do the trick - (ChrisR) - (2) - May 13, 2003, 11:14:52 PM EDT
             Thanks - (broomberg) - (1) - May 13, 2003, 11:30:19 PM EDT
                 Probably the best way... - (ChrisR) - May 14, 2003, 01:12:24 AM EDT

And she wasn't kidding, either, 'cause in came the biggest, meanest looking haddock I'd ever seen come down the pike. He was covered with mussels.
78 ms