SFreilinger
Programmer
OK, I have read a bunch of stuff around this and thought I had it figured out. Here is what I have
I have a non-sysadmin user (User1) running a Scheduled Job. User1 is the owner of the scheduling job (so he can see it). The Scheduled job kicks off a DTS Job that is owned by a second user (User2) with sysadmin and is the startup account for SQL Services. Both users have access to a network resource (fileshare). The DTS Job grabs a text file and imports the data to a table. The job is failing. It works if User2 kicks off either the scheduled job or the DTS Job. I am guessing the the DTS Job is running under SQLAgentCmdExec even though User2 has sysadmin.
If anyone has an idea how to accomplish this, I would appreciate it.
I have a non-sysadmin user (User1) running a Scheduled Job. User1 is the owner of the scheduling job (so he can see it). The Scheduled job kicks off a DTS Job that is owned by a second user (User2) with sysadmin and is the startup account for SQL Services. Both users have access to a network resource (fileshare). The DTS Job grabs a text file and imports the data to a table. The job is failing. It works if User2 kicks off either the scheduled job or the DTS Job. I am guessing the the DTS Job is running under SQLAgentCmdExec even though User2 has sysadmin.
If anyone has an idea how to accomplish this, I would appreciate it.
