Multiple jobs on one schedule

17 Mar 2006 11:08 AM

brin

Hi

I am wondering if it's possible to run multiple backup jobs from one shedule
in SQL Server 2000, so all backups are triggered simultaneously at a given
time.

Having looked at the sysjobs and sysjobsschedules tables in msdb it seems
they have a 1 to 1 relationship and this leads me to believe this is not
possible. Has anyone else ever achieved this, and if so, how?

Thanks in advance

Brin

17 Mar 2006 11:17 AM

Uri Dimant

bin

The second backup will wait till the first one completed.
What is the purpose?

Show quoteHide quote

"brin" <brin_z{nospam}@hotmail.com> wrote in message
news:uZV$LObSGHA.1204@TK2MSFTNGP12.phx.gbl...
> Hi
>
> I am wondering if it's possible to run multiple backup jobs from one
> shedule in SQL Server 2000, so all backups are triggered simultaneously at
> a given time.
>
> Having looked at the sysjobs and sysjobsschedules tables in msdb it seems
> they have a 1 to 1 relationship and this leads me to believe this is not
> possible. Has anyone else ever achieved this, and if so, how?
>
> Thanks in advance
>
> Brin
>

17 Mar 2006 11:40 AM

brin

It just seemed a bit more organised to use the one schedule as all we are
doing is repeating data in sysjobschedules, this is for around 25 databases
each with 2 backup schedules. We are about to rescheule the time they run
anyway so thought it may be a worthwhile excercise.

Thanks again

Show quoteHide quote

"Uri Dimant" <u***@iscar.co.il> wrote in message
news:%23TM$8QbSGHA.5780@TK2MSFTNGP10.phx.gbl...
> bin
>
> The second backup will wait till the first one completed.
> What is the purpose?
>
>
>
>
> "brin" <brin_z{nospam}@hotmail.com> wrote in message
> news:uZV$LObSGHA.1204@TK2MSFTNGP12.phx.gbl...
>> Hi
>>
>> I am wondering if it's possible to run multiple backup jobs from one
>> shedule in SQL Server 2000, so all backups are triggered simultaneously
>> at a given time.
>>
>> Having looked at the sysjobs and sysjobsschedules tables in msdb it seems
>> they have a 1 to 1 relationship and this leads me to believe this is not
>> possible. Has anyone else ever achieved this, and if so, how?
>>
>> Thanks in advance
>>
>> Brin
>>
>
>

17 Mar 2006 12:53 PM

John Bell

Hi

If you schedule mutiple jobs that hit the same discs you may see a
performance bottleneck. You may want to look at having one job with multiple
steps!

John

Show quoteHide quote

"brin" wrote:

> It just seemed a bit more organised to use the one schedule as all we are
> doing is repeating data in sysjobschedules, this is for around 25 databases
> each with 2 backup schedules. We are about to rescheule the time they run
> anyway so thought it may be a worthwhile excercise.
>
> Thanks again
>
>
> "Uri Dimant" <u***@iscar.co.il> wrote in message
> news:%23TM$8QbSGHA.5780@TK2MSFTNGP10.phx.gbl...
> > bin
> >
> > The second backup will wait till the first one completed.
> > What is the purpose?
> >
> >
> >
> >
> > "brin" <brin_z{nospam}@hotmail.com> wrote in message
> > news:uZV$LObSGHA.1204@TK2MSFTNGP12.phx.gbl...
> >> Hi
> >>
> >> I am wondering if it's possible to run multiple backup jobs from one
> >> shedule in SQL Server 2000, so all backups are triggered simultaneously
> >> at a given time.
> >>
> >> Having looked at the sysjobs and sysjobsschedules tables in msdb it seems
> >> they have a 1 to 1 relationship and this leads me to believe this is not
> >> possible. Has anyone else ever achieved this, and if so, how?
> >>
> >> Thanks in advance
> >>
> >> Brin
> >>
> >
> >
>
>
>

17 Mar 2006 11:41 AM

Steen Persson (DK)

brin wrote:
Show quoteHide quote

> Hi
>
> I am wondering if it's possible to run multiple backup jobs from one shedule
> in SQL Server 2000, so all backups are triggered simultaneously at a given
> time.
>
> Having looked at the sysjobs and sysjobsschedules tables in msdb it seems
> they have a 1 to 1 relationship and this leads me to believe this is not
> possible. Has anyone else ever achieved this, and if so, how?
>
> Thanks in advance
>
> Brin
>
>

I think the closest you can get, it to create multiple jobs that starts
at the same time. I don't quite see the need for it though, but I assume
you have a reason for it?

Regards
Steen