Viewing 4 posts - 1 through 4 (of 4 total)
Hi,
This issue is now fixed. Thank you for your help.
September 29, 2008 at 9:51 am
#878477
When I run the job manually, I login using sysadmin and just run the job.
The account that starts SQL Server agent is 'LocalSystem'. I can change the permission...
September 26, 2008 at 7:59 am
#877706
Here is the answer to your questions.
What to Step 1 do? ===> Step 1 runs a SQL Script that copies some data from Informix to SQL Server. ...
September 25, 2008 at 9:09 am
#877085
SQL server start up account is 'system account'. Is that 'sa'? DTS package is owned by MIS-Server/Administrator; Scheduled job is owned by 'sa'
Thanks.
September 25, 2008 at 9:01 am
#877076