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 execution

Greetings.

We generate table exports on a SQL Server 2005 instance at irregular intervals. Often when exports are required we have a number of them that need to be run. We've found that the exports job run sequentially. Is there a way of simultaneously executing the jobs ?

Thanks.

alan

If you are referring to several steps in a SQL Agent Job, then they always run sequentially. You could make a separate Job for each of the steps, and, depending upon your server hardware and the user activity, they may then run in parallel.

You could create a DTS (SQL 2000) or SSIS (SQL 2005) package, and in the package you could easily extablish that the various 'steps' were to run in parallel.

|||

Very helpful.

Thank you.