Distributing Jobs in SQL

[Ken]

I want to know if there is anyway to distribute jobs to a non system
administrator. In other words do they have to have System Admin rights, to be able to modify a job and run the job.

[BobH]

You may be able to create a sproc that uses the system stored procedures sp_add_Job** and sp_update_job** and then give the users execute rights to the sproc you created.


------------
Ken at 3/22/01 2:42:15 PM


I want to know if there is anyway to distribute jobs to a non system
administrator. In other words do they have to have System Admin rights, to be able to modify a job and run the job.