Friday, March 9, 2012
Schedule the shutdown selected clients.
We running a Win 2000 domain with XP sp2 clients.
I have been asked to find a way to shutdown selected clients on a Friday
evening. Is there any way to schedule this through a GPO?
I am considering configuring a script to run shutdown.exe in a batch file
but obviously this offers no way to control the process centrally. Does
anyone know of a better way?
Ideally I would like to save any documents left open before the shutdown.
All advice is greatly appreciated. Simon.Hi
This is the SQL Server NG, you may get a bettwer answer by posting this to
the .Windows.* NG.
Off the top of my head, look at http://www.microsoft.com/smserver/ and
http://www.microsoft.com/MOM/
Regards
Mike
"Simon" wrote:
> Hi all,
> We running a Win 2000 domain with XP sp2 clients.
> I have been asked to find a way to shutdown selected clients on a Friday
> evening. Is there any way to schedule this through a GPO?
> I am considering configuring a script to run shutdown.exe in a batch file
> but obviously this offers no way to control the process centrally. Does
> anyone know of a better way?
> Ideally I would like to save any documents left open before the shutdown.
> All advice is greatly appreciated. Simon.
>
>
Schedule the shutdown selected clients.
We running a Win 2000 domain with XP sp2 clients.
I have been asked to find a way to shutdown selected clients on a Friday
evening. Is there any way to schedule this through a GPO?
I am considering configuring a script to run shutdown.exe in a batch file
but obviously this offers no way to control the process centrally. Does
anyone know of a better way?
Ideally I would like to save any documents left open before the shutdown.
All advice is greatly appreciated. Simon.
Hi
This is the SQL Server NG, you may get a bettwer answer by posting this to
the .Windows.* NG.
Off the top of my head, look at http://www.microsoft.com/smserver/ and
http://www.microsoft.com/MOM/
Regards
Mike
"Simon" wrote:
> Hi all,
> We running a Win 2000 domain with XP sp2 clients.
> I have been asked to find a way to shutdown selected clients on a Friday
> evening. Is there any way to schedule this through a GPO?
> I am considering configuring a script to run shutdown.exe in a batch file
> but obviously this offers no way to control the process centrally. Does
> anyone know of a better way?
> Ideally I would like to save any documents left open before the shutdown.
> All advice is greatly appreciated. Simon.
>
>
Schedule the shutdown selected clients.
We running a Win 2000 domain with XP sp2 clients.
I have been asked to find a way to shutdown selected clients on a Friday
evening. Is there any way to schedule this through a GPO?
I am considering configuring a script to run shutdown.exe in a batch file
but obviously this offers no way to control the process centrally. Does
anyone know of a better way?
Ideally I would like to save any documents left open before the shutdown.
All advice is greatly appreciated. Simon.Hi
This is the SQL Server NG, you may get a bettwer answer by posting this to
the .Windows.* NG.
Off the top of my head, look at http://www.microsoft.com/smserver/ and
http://www.microsoft.com/MOM/
Regards
Mike
"Simon" wrote:
> Hi all,
> We running a Win 2000 domain with XP sp2 clients.
> I have been asked to find a way to shutdown selected clients on a Friday
> evening. Is there any way to schedule this through a GPO?
> I am considering configuring a script to run shutdown.exe in a batch file
> but obviously this offers no way to control the process centrally. Does
> anyone know of a better way?
> Ideally I would like to save any documents left open before the shutdown.
> All advice is greatly appreciated. Simon.
>
>
Tuesday, February 21, 2012
Schedule at Month End
I selected monthly, and tried to put 28,29,30,31 in calendar days, since
months vary, but I get this error "To create a schedule that runs on
multiple days, you must choose which days to use"
Any Ideas? I run monthly reports that create snapshots. I guess I
could run it at 12:01 on the 1st of the month, I but I used stored
procedures to calculate default dates and it really needs to run on the
last day of the month.
Thanks.Also, in addition to John's question, I have another question. How do I
name the report dynamically? If my report is for every month end, I want to
name it accordinly - JAN2005.csv, or something like that. In report Manager,
didn't see any option in generating filename.
Thanks
"John Geddes" wrote:
> How do I create a schedule to run at month end?
> I selected monthly, and tried to put 28,29,30,31 in calendar days, since
> months vary, but I get this error "To create a schedule that runs on
> multiple days, you must choose which days to use"
> Any Ideas? I run monthly reports that create snapshots. I guess I
> could run it at 12:01 on the 1st of the month, I but I used stored
> procedures to calculate default dates and it really needs to run on the
> last day of the month.
> Thanks.
>|||RS does not support this recurrence (last day of month). Your best bet is
to do what you suggested below. There is a way to get around this but it
has some side effects. After you create the schedule, find the
corresponding job in SQL Agent (doesn't matter what schedule you create
initially). Create the 12 schedules you will need in the sql agent job.
Now, RS will by default detect that the job is inconsistent with the RS
metadata and will update it. You can turn this off by updating the
IsSchedulingService to false in the RSReportServer.config file. Of course
by doing this RS will never check for consistency and it will be possible
for someone to update the schedules via SQL Agent (which is what you would
have done) and the recurrence will not correspond to what is being shown to
the user.
As for Vipul question, you can only accomplish this via Data Driven
subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vipul Shah" <VipulShah@.discussions.microsoft.com> wrote in message
news:9790438A-4833-4E9C-888A-47C43930CB28@.microsoft.com...
> Also, in addition to John's question, I have another question. How do I
> name the report dynamically? If my report is for every month end, I want
> to
> name it accordinly - JAN2005.csv, or something like that. In report
> Manager,
> didn't see any option in generating filename.
> Thanks
> "John Geddes" wrote:
>> How do I create a schedule to run at month end?
>> I selected monthly, and tried to put 28,29,30,31 in calendar days, since
>> months vary, but I get this error "To create a schedule that runs on
>> multiple days, you must choose which days to use"
>> Any Ideas? I run monthly reports that create snapshots. I guess I
>> could run it at 12:01 on the 1st of the month, I but I used stored
>> procedures to calculate default dates and it really needs to run on the
>> last day of the month.
>> Thanks.
>>
Schedule a report to run at a particular time with user filled parameters
I have a report that I would like to run in the evening due to high database usage that required a user to fill in selected parameters. Is there anyway to allow a user to fill in the report parameters and have it scheduled to run at 3:00 AM.
Thanks,
Chris
You could use a data driven subscription, which relies on a table you create to store the parameters for the report. Then provide the user with a simple interface to set the parameters in the table.
Or you could let them create a linked report in their My Reports folder, and set up their own subscription from there, which allows them to specify parameters values.
|||Would you mind elaborating on this technique, or pass along some documentation/samples for this? I am most interested in how you setup this 'table' that stores the parameters for the report and of course how you configure the report to use the values in the table.Thanks!|||
I never did find a great solution to this problem. Please let me know if you do find one.
Thanks,
|||What part of the solutions that you were offered didn't you like? I thought they were both good, depending on business requirements, and I wasn't too sure from what you described which one would meet yours... but didn't expect to hear that you used neither <s>.
So... what was the issue in your case?
>L<
PS. You can also roll your own. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2022350&SiteID=1. But I'm not (yet) convinced you need to, in your case...
|||Neither of the above options worked for you?
Schedule a report to run at a particular time with user filled parameters
I have a report that I would like to run in the evening due to high database usage that required a user to fill in selected parameters. Is there anyway to allow a user to fill in the report parameters and have it scheduled to run at 3:00 AM.
Thanks,
Chris
You could use a data driven subscription, which relies on a table you create to store the parameters for the report. Then provide the user with a simple interface to set the parameters in the table.
Or you could let them create a linked report in their My Reports folder, and set up their own subscription from there, which allows them to specify parameters values.
|||Would you mind elaborating on this technique, or pass along some documentation/samples for this? I am most interested in how you setup this 'table' that stores the parameters for the report and of course how you configure the report to use the values in the table.Thanks!
|||
I never did find a great solution to this problem. Please let me know if you do find one.
Thanks,
|||What part of the solutions that you were offered didn't you like? I thought they were both good, depending on business requirements, and I wasn't too sure from what you described which one would meet yours... but didn't expect to hear that you used neither <s>.
So... what was the issue in your case?
>L<
PS. You can also roll your own. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2022350&SiteID=1. But I'm not (yet) convinced you need to, in your case...
|||Neither of the above options worked for you?Schedule a report to run at a particular time with user filled parameters
I have a report that I would like to run in the evening due to high database usage that required a user to fill in selected parameters. Is there anyway to allow a user to fill in the report parameters and have it scheduled to run at 3:00 AM.
Thanks,
Chris
You could use a data driven subscription, which relies on a table you create to store the parameters for the report. Then provide the user with a simple interface to set the parameters in the table.
Or you could let them create a linked report in their My Reports folder, and set up their own subscription from there, which allows them to specify parameters values.
|||Would you mind elaborating on this technique, or pass along some documentation/samples for this? I am most interested in how you setup this 'table' that stores the parameters for the report and of course how you configure the report to use the values in the table.Thanks!
|||
I never did find a great solution to this problem. Please let me know if you do find one.
Thanks,
|||What part of the solutions that you were offered didn't you like? I thought they were both good, depending on business requirements, and I wasn't too sure from what you described which one would meet yours... but didn't expect to hear that you used neither <s>.
So... what was the issue in your case?
>L<
PS. You can also roll your own. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2022350&SiteID=1. But I'm not (yet) convinced you need to, in your case...
|||Neither of the above options worked for you?