You are here: Re: Setting up scheduled jobs for different days with different intervals « MsSQL Server « IT news, forums, messages
Re: Setting up scheduled jobs for different days with different intervals

Posted by teddysnips on 10/02/81 11:56

Stu wrote:

> Instead of multiple jobs, why not a single job with multiple schedules?
> Create a schedule for each day of the week with the appropriate
> scheduling parameters. You coule also build an interface to execute
> the sp_update_jobschedule stored procedure to alter the frequency of
> the job runs.
>
> Not as cool as Notification Services, but it fits the need you
> describe....
>
> Stu

Thanks to you Stu, as well as Erland and David for these excellent
ideas. If I can't make Notification Services work as required, I'm
sure that this will serve very well.

Edward

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация