Hi,

I created a DTS job, I need win user group able to exec that DTS through
TDYrun untility.

How do I grant permssion to that group

Thanks

Hello mecn,

Have you created a Job that fires a DTS package or just a package?

Where is the package stored?

To execute a job look here

http://msdn.microsoft.com/library/de...sa-sz_11uq.asp


Packages can have passwords and if the package has one then you will need
to supply it.


If the package is in MSDB then by default public can fire them.


Without more specific info I cannot be more specific.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanks for response.
I have an internal application need to call xp_cmdshell to exec the DTS
package or sql job to exec the package.
Only sysadmin could exec xp_cmdshell. I can't set the windows group as sql
server sysadmin in order to run the xp_cmdshell.


Thanks

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote