Agent stops and won't restart

Various sites/servers this is happening.
Start Server AGent
Schedule a DTS to run nightly.
Come back a few days later
SQL SA is stopped
the job never ran
When this first happened I checked the props of SQLSA
and found the "Auto - Restart SQL Server on failure" and "A-R SQL SA..." check boxes.
Checked them.
Come back a few days later. Same results
When I view the jobs in SQL SA- Jobs area those jobs failed for the inimitable
sqlstate 42000 error 8198 "... if the owner
(server\administrator) of job Nightly Update has server access (reason: Could
not obtain information about ... 'server\administrator'.
Yes, the adminitrator. Now I've changed the owner of the jobs to
sa. I'm afraid to presume that sa is powerful enough to stand up to SQL authentication if the admin can't (smirk)
Does anyone have any insights? would the 8198 cause SA to stop? Why would a subordinate job stop SA?
if the sub-job can stop it why doesn't it restart as told to in the properties?
thanks, Bryan
Hi Bryan,
An 8198 error is normally raised when process executed within SQL Server or
from the SQL Server Agent, such as the "xp_logininfo" stored procedure, a
scheduled job, or a replication agent, needs to verify the credentials of a
Windows-authenticated login. The attempt to retrieve those credentials on
the domain failed for an unspecified reason
Please take a look at article
http://support.microsoft.com/default...b;en-us;883551 that talks
about some of the reasons for the 8198 error that you are getting.
Hope that helps !!!
Fargham

Advise: DTS

Version: SQL Server 7.0
App: MS Access 2000

I created DTS to move records from MySQL to SQL Server (approx over 500,000+
per months dataset) for purpose of canned and adhoc reporting. The app
have a simple interface using MS Access where user will input the timeframe
of the dataset they will process.

Both servers are physically located in the same bldg from another state.
Previous to MySQL, they send us cd in text format and my app runs the DTS
using a BAT file containing the DTSRUN command. But I would like stay away
from the DTSRUN since they take awhile to load to the server, plus it runs
on background on client pc. I wanted a functionality where it will run on
the server without user supervision, and they can go about their business
and do something else. In other words, let the server do majority of the
work.

Now that MySQL came into the picture, the Network Support created a filedsn
where sqlserver sits and I use that as a reference on my DTS (using UNC,
\\myserver\file$\sample.dsn)

The problem:
1) I work from home and when creating and running this DTS's, it takes a
while to process;
2) When specifying the UNC path on DTS and saved, for some reason it
switches to the User/System DSN section;
3) I also tested from office with the same result (i connect using cable
modem)

Now the only way I can think of to solve this problem:
a) save the DTS as a file and send it over to Network Support and have them
load it up and manually change the source location OR have them modify the
DTS and change the source location
b) then create a DTS job

The person who will be running this DTS might be running it from home or
office. Also, is there a way to automate the DTS job using an SP? I wanted
to make it as easier as possible for the end user, where all they have to do
is enable the job and run only for this time and for this package.

TIA!
BobHi

You can schedule the DTS package to run periodically on your SQL Server.
Look at sp_add_job and associated procedures as descibed in the topic "How
to create a job (Transact-SQL)" in Books online or the topic "How to create
a job (Enterprise Manager)" to do it manually through EM.

If you don't want run a job without a schedule look at the "Running Jobs"
topic for sp_start_job.

John

"B" <no_spam@.no_spam.com> wrote in message
news:415580f5$0$4029$61fed72c@.news.rcn.com...
> Version: SQL Server 7.0
> App: MS Access 2000
> I created DTS to move records from MySQL to SQL Server (approx over
500,000+
> per months dataset) for purpose of canned and adhoc reporting. The app
> have a simple interface using MS Access where user will input the
timeframe
> of the dataset they will process.
> Both servers are physically located in the same bldg from another state.
> Previous to MySQL, they send us cd in text format and my app runs the DTS
> using a BAT file containing the DTSRUN command. But I would like stay
away
> from the DTSRUN since they take awhile to load to the server, plus it runs
> on background on client pc. I wanted a functionality where it will run on
> the server without user supervision, and they can go about their business
> and do something else. In other words, let the server do majority of the
> work.
> Now that MySQL came into the picture, the Network Support created a
filedsn
> where sqlserver sits and I use that as a reference on my DTS (using UNC,
> \\myserver\file$\sample.dsn)
> The problem:
> 1) I work from home and when creating and running this DTS's, it takes a
> while to process;
> 2) When specifying the UNC path on DTS and saved, for some reason it
> switches to the User/System DSN section;
> 3) I also tested from office with the same result (i connect using cable
> modem)
> Now the only way I can think of to solve this problem:
> a) save the DTS as a file and send it over to Network Support and have
them
> load it up and manually change the source location OR have them modify the
> DTS and change the source location
> b) then create a DTS job
> The person who will be running this DTS might be running it from home or
> office. Also, is there a way to automate the DTS job using an SP? I
wanted
> to make it as easier as possible for the end user, where all they have to
do
> is enable the job and run only for this time and for this package.
> TIA!
> Bob
>