Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peace
Constraint Violating Yak Guru
420 Posts |
 Posted - 2011-12-23 : 01:51:14
|
| Is there any way to restart SQL Server Reporting Services via query to schedule every week?Usually i need to manually go to SQL Server Configuration Manager to restart there. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-23 : 01:59:14
|
| why should you restart the services each week?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2011-12-23 : 02:11:09
|
| to make it smoother and faster to load the report out.so was thinking is there any query to execute to restart. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-23 : 03:16:21
|
| hmm..under normal conditions i dont think you need a regular restart of services. Without it, what issues you're facing?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2011-12-23 : 03:58:38
|
| No issue actually. Just to speed up to generate report.Is this possible?@ECHO OFFNET STOP SQLSERVERAGENTNET STOP MSSQLSERVERNET START MSSQLSERVER NET START SQLSERVERAGENT |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-23 : 04:01:59
|
| its possible if you put it inside a bat and schedule it.You can even call bat from xp_cmdshell if you want------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SQL Server Reporting Services