hi all
we have about 10 jobs running each taking less than 45 minutes. they are scheduled in such a way that they dont overlap.
one of the job ocassionaly takes about 6-8 hrs to run.this happens thrice a week.
programmers incur problems due to limited functionalities in front end.
dont know why this happens.
any solutions for this problem plzzzz
thank u all
vignesh kannan :) :confu...
vigneshkannan
Last Activity: Apr 26 '06, 02:44 PM
Joined: Apr 26 '06
Location:
-
job runs a little too long....
-
hi robin,
When a SQL job has been created to run a local DTS package as per schedule it fails with the following error message.
The job failed. Unable to determine if the owner
(DomainName\Use rAccount) of job MyJobName has server access (reason:
Could not obtain information about Windows NT group/user '
DomainName\User Account'. [SQLSTATE 42000] (Error 8198)).
found ur post ..
how did... -
error 8198 when job is run
When a SQL job has been scheduled to run a DTS package automatically it fails with the following error message.
The job failed. Unable to determine if the owner
(DomainName\Use rAccount) of job MyJobName has server access (reason:
Could not obtain information about Windows NT group/user '
DomainName\User Account'. [SQLSTATE 42000] (Error 8198)).
The package runs if executed from the DTS Local Packages...
No activity results to display
Leave a comment: