Scheduling of data warehousing and other tasks
![](http://jazz.net/_images/myphoto/613d7de5ff19782cdb65a899a978d2f7.jpg)
Hi,
since we have more servers and applications on the same HW machine, I
would like to avoid batch/scheduled tasks to run at the same time on the
server (e.g. data warehousing scheduled to start at 0:05).
I was wondering: when the jazz scheduler start e.g. DW? I can find delay
parameter only...
Thanks!
Roman
since we have more servers and applications on the same HW machine, I
would like to avoid batch/scheduled tasks to run at the same time on the
server (e.g. data warehousing scheduled to start at 0:05).
I was wondering: when the jazz scheduler start e.g. DW? I can find delay
parameter only...
Thanks!
Roman
4 answers
![](http://jazz.net/_images/myphoto/613d7de5ff19782cdb65a899a978d2f7.jpg)
Set the following advanced property for each of your servers:
"Data Warehouse Snapshot Time" to a value between 1 and 24. This will be the hour at which all snapshots will run for that particular server. Notice that the snapshots will not run at the same time. They will form a queue and only one will be running. This applies to only the data warehouse snapshot tasks.
"Data Warehouse Snapshot Time" to a value between 1 and 24. This will be the hour at which all snapshots will run for that particular server. Notice that the snapshots will not run at the same time. They will form a queue and only one will be running. This applies to only the data warehouse snapshot tasks.
![](http://jazz.net/_images/myphoto/613d7de5ff19782cdb65a899a978d2f7.jpg)
Thanks, Rafik. Roman
"rjaouani" <rjaouani> wrote in message
news:gmqggq$spq$2@localhost.localdomain...
"rjaouani" <rjaouani> wrote in message
news:gmqggq$spq$2@localhost.localdomain...
Set the following advanced property for each of your servers:
"Data Warehouse Snapshot Time" to a value between 1 and 24.
This will be the hour at which all snapshots will run for that
particular server. Notice that the snapshots will not run at the same
time. They will form a queue and only one will be running. This
applies to only the data warehouse snapshot tasks.
![](http://jazz.net/_images/myphoto/613d7de5ff19782cdb65a899a978d2f7.jpg)
Hi,
I have a question: where I find this property? In my Admin web page I don't see it. :(
http://img199.imageshack.us/img199/8962/datawarehouse.jpg
Thanks
Andrea
I have a question: where I find this property? In my Admin web page I don't see it. :(
Thanks
Andrea
Set the following advanced property for each of your servers:
"Data Warehouse Snapshot Time" to a value between 1 and 24. This will be the hour at which all snapshots will run for that particular server. Notice that the snapshots will not run at the same time. They will form a queue and only one will be running. This applies to only the data warehouse snapshot tasks.