Re: SBS 2003 - Sql server -management- scheduled job stops running.

Tech-Archive recommends: Fix windows errors by optimizing your registry

mvk wrote:

Recently moved my DB application from a SBS 4.5 to SBS 2003. The transfer of
data went very smoothly. What I have been expericiencing though is that every
6 days or so I have to stop and start the sql server services (ver. 8.0) due
to my sql agent jobs stops processing my VB application at the scheduled time
created. The job shows that its still running but it isn't running as it has
been scheduled to run every 5 minutes. Once the scheduled jobs have been
restarted I have 6 days until it does it again like clock work. Never had
this problem when running on SBS 4.5.

I also run across the same problem with my internal web page used for
administration and report sending after so many days the the reports will
start generating a run time error. After rebooting the server everything is
back to normal.

Any suggestions to resolve this would be very helpful.

SQL Server Agent will only start recurring jobs on schedule if the previous pass has completed. Since you indicate that SQL Server Agent thinks the job is running, it *won't* start the job again. You need to investigate what's actually happening when SQL Server Agent kicks the job off for the first time.

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.
.

Relevant Pages

  • Re: Autostart MS Agent on Win98/Me
    ... If you really rely on SQL Server Agent being started and you have not a lot ... > with Entreprise manager and the agent start with WinNT... ... I can manually start the agent with the MSDE service manager, ...
    (microsoft.public.sqlserver.msde)
  • Re: Can MSDE run SQL Server Agent service in Win98
    ... >> SQL Server Agent service. ... > AFAIK the SQL Server Agent runs on Win9x with no problem..... ... > run as a service becouse Win9x does not support it, ...
    (microsoft.public.sqlserver.msde)
  • RE: DTS Package fails when Scheduled
    ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Re: Error running DTS package on a schedule (only!)
    ... Right Click on the SQL Server Agent icon in EM and choose properties. ... > How do I determine which account was used to start SQL Agent? ... >> | When I try to schedule a job for this DTS package under SQL Server ...
    (microsoft.public.sqlserver.dts)
  • Re: Win 2003 upgrade
    ... Then I would start it up SQL Server agent and see if I can't identify the ... For the problem with the retention period of expiring subscribers, ... 'The subscription has not been synchronized within the maximum ...
    (microsoft.public.sqlserver.replication)