job security and permission required

Hi,
What permission is required to create and execute the job successfully?
Switch job ownership to A, but A can't execute job successfully. In the job
, there is DTS and stored procedure. What permission is required?
Thank you.
YulingSee:
269074 INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

JOB creation permission

Hi,
How can I prevent a user from creating a Sql Agent Job?
Thanks,
AlanA.M wrote:
> Hi,
> How can I prevent a user from creating a Sql Agent Job?
> Thanks,
> Alan
Get them out of the server role that's giving them rights or explicity
revoke them. If they're an administratot they already have full rights.
What group does the user belong to?
Exec sp_helpuser '<name>' -- current db
EXEC sp_helplogins '<name>'
Exec sp_helpsrvrolemember
David Gugick
Imceda Software
www.imceda.com|||Unfortunately, there's a guest user in msdb. Also, EXEC permissions is grant
ed on sp_add_job (etc)
to public in msdb. Remove any of these (just think it through which one is b
est in your
environment). Adding the login to msdb as an explicit user and DENY on sp_ad
d_job is also an option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"A.M" <nospam1@.online.nospam> wrote in message news:OTFqXptEFHA.2828@.TK2MSFTNGP09.phx.gbl..
.
> Hi,
> How can I prevent a user from creating a Sql Agent Job?
> Thanks,
> Alan
>