|
|
||||||
|
#1
03-17-06, 11:08 AM
|
|
|
|
|
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 |
|
|
|
#2
03-17-06, 11:17 AM
|
|
|
|
|
bin
The second backup will wait till the first one completed. What is the purpose? "brin" <brin_z{nospam}> wrote in message news:1204 [..] |
|
#3
03-17-06, 11:40 AM
|
|
|
|
|
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" <urid> wrote in message news:5780 [..] |
|
#4
03-17-06, 11:41 AM
|
|
|
|
|
brin wrote:
> 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 |
|
#5
03-17-06, 12:53 PM
|
|
|
|
|
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 "brin" wrote: [..] |
|
|
| Similar Threads | |
| SQLagent jobs schedule I'm running a test, but I have a job that I want to start at 3:10 AM and end at 2:50 AM. SQLagent took the job, but it isn't starting and when I ran it one time manually, it... |
|
| SSIS and Schedule Jobs We recently upgrade from SQL 2000 to 2005 and everything works great. But I have a problem which I know due of lack of knowledge. When I create a SSIS package with "SQL... |
|
| Change Schedule jobs I have restore various dbs from one server to another server, this to include the msdb, model and master dbs. I wanted to stop the jobs from run on my new server, and rename... |
|
| DTS/Schedule Jobs monitoring Is there a way to monitor all scheduled DTS jobs and restart the jobs automatically when it faillS. If the job continues failing after being restarted for several times then... |
|
| schedule jobs How can i create a stored procedure that runs a sql schedule or update the date and time for a schedule job. |
|
|
All times are GMT. The time now is 03:34 AM. | Privacy Policy
|
Multiple jobs on one schedule