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. |