dbTalk Databases Forums  

Scheduled DTS job failing to run

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Scheduled DTS job failing to run in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim
 
Posts: n/a

Default Scheduled DTS job failing to run - 04-22-2005 , 12:54 PM






The sqlserveragent service is set to start automatically with a local service
account instead of the sqladmin account.

The application error log states :
The description for Event ID ( 208 ) in Source ( SQLSERVERAGENT ) cannot be
found. The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. You may be able
to use the /AUXSOURCE= flag to retrieve this description; see Help and
Support for details. The following information is part of the event:
Mas_to_SQL, 0xECED9394666EC141BD2658BBE7B908DB,
Failed, 2005-04-22 02:00:00, The job failed. The Job was invoked by
Schedule 2 (Mas_to_SQL). The last step to run was step 1 (Mas_to_SQL)..

The job will execute manually with no problems. The owner of the job is a
windows account and I do not have the access rights to change this
information.

The information I have been reading has been leaning me towards changing the
owner of the job to the 'sa' account and to have the sqlagent be run by an
sql administrative account but i'm not sure if this is the problem.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.