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

Steve,

Thanks for responding, I'll check it closer to see what happens when it
occurs again possibly within the next 24 hours. Hopefully it will generate
an event error to hopefully point me to a possible resolution.

Michael

"Steve Foster [SBS MVP]" wrote:

> 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: DTS Scheduled Package Fails but runs manually
    ... who has no right to access remote folders. ... Make sure SQL server Agent service runs under a proper account (? ... > Transformation Services Flat File Rowset Provider Help file: ... > Any ideas why it runs manually and not through a schedule? ...
    (microsoft.public.sqlserver.dts)
  • RE: Next run date!
    ... there is a schedule set up for this job. ... right click on "Jobs" under SQL Server Agent and choose refresh. ... If it also does not show up in MSDB database, ... following article on SQL Server Books Online. ...
    (microsoft.public.sqlserver.server)
  • SQL Server Agent permissions
    ... I am trying to schedule backup jobs - seemingly very simple however, ... If I look at the "Display Error Log" when right-click on SQL Server Agent it ... username is invalid for database 'master'. ...
    (microsoft.public.sqlserver.setup)
  • Re: Programatically schedule a DTS package
    ... create a SQL server Agent job and schedule it. ... Francesco Anti ...
    (microsoft.public.sqlserver.dts)
  • Re: SBS 2003 - Sql server -management- scheduled job stops running
    ... Let me clarify what I'm really trying to convey regarding my issue. ... Is this a SQL Server Agent job, or some other sort of job? ... Steve Foster [SBS MVP] ...
    (microsoft.public.windows.server.sbs)