| Author |
Message |
Andre Pronk [Deloitte]
Guest
|
 Posted:
Fri Oct 28, 2005 8:51 am Post subject:
Schedule custom report over >1 day ..... |
|
|
Hi,
Does anyone has any tips on how to schedule a report over less then 1 day ?
Manual is no problem, but if I want a schedule to run fi. over the past 8
hours, the default options aren't helpfull.
I've checked the default reports but theu use the SC_CurrentDate view.
(Begindate = currentdate - @numberofdays) Is it even possible possible ?
--
Andre Pronk
Executive Office ICT Services
Network Operating Center
http://www.deloitte.nl |
|
| Back to top |
|
 |
Andre Pronk [Deloitte]
Guest
|
| Posted:
Fri Oct 28, 2005 8:51 am Post subject:
RE: Schedule custom report over <1 day ..... |
|
|
Sorry, wrong sign for "smaller then".
--
Andre Pronk
Executive Office ICT Services
Network Operating Center
http://www.deloitte.nl
"Andre Pronk [Deloitte]" wrote:
| Quote: | Hi,
Does anyone has any tips on how to schedule a report over less then 1 day ?
Manual is no problem, but if I want a schedule to run fi. over the past 8
hours, the default options aren't helpfull.
I've checked the default reports but theu use the SC_CurrentDate view.
(Begindate = currentdate - @numberofdays) Is it even possible possible ?
--
Andre Pronk
Executive Office ICT Services
Network Operating Center
http://www.deloitte.nl |
|
|
| Back to top |
|
|
davidtyra@hotmail.com
Guest
|
| Posted:
Fri Oct 28, 2005 4:51 pm Post subject:
Re: Schedule custom report over <1 day ..... |
|
|
Andre,
Certainly you can schedule a report subscription to run more than once
per day. However, unless you change the DTS package to run more often
than once per day, there would be no point to doing this as the data
would not change between report runs. Since the DTS task can only be
scheduled to run daily, you would need to run the task manually or
create multiple DTS tasks to get multiple runs per day. Because this
affects the grooming task, I would test this thoroughly before
attempting it in a production environment. I do know we have run the
DTS package manually outside of the schedule a few times without any
problems.
Regards,
David Tyra |
|
| Back to top |
|
|
Andre Pronk [Deloitte]
Guest
|
| Posted:
Sun Oct 30, 2005 5:50 pm Post subject:
Re: Schedule custom report over <1 day ..... |
|
|
David,
We've already adjusted the scheduled job and had no issues with that.
The problem I describe is when you create a custom report and you want to
schedule it for delivery. In this report I only want data of the last 8
hours, but then I have to create or adjust the function that retrieves the
date and the date -1.
The problem is that you have to switch from day to hour, and I have not yet
an idea how to do that.
--
Andre Pronk
Executive Office ICT Services
Network Operating Center
http://www.deloitte.nl
"davidtyra@hotmail.com" wrote:
| Quote: | Andre,
Certainly you can schedule a report subscription to run more than once
per day. However, unless you change the DTS package to run more often
than once per day, there would be no point to doing this as the data
would not change between report runs. Since the DTS task can only be
scheduled to run daily, you would need to run the task manually or
create multiple DTS tasks to get multiple runs per day. Because this
affects the grooming task, I would test this thoroughly before
attempting it in a production environment. I do know we have run the
DTS package manually outside of the schedule a few times without any
problems.
Regards,
David Tyra
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in