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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2013-01-04 : 09:46:20
|
| Hi Team,I need a help for the below1.sqldatabase backup job failures from all servers2.diskspace utilization from all servers3.Logspace utilization from all serversThese need to be generated as single Excel file and send to mailid everday |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2013-01-04 : 09:53:55
|
| What sort of connectivity do you have and do you have a list of the servers you need to access?Might be better to do this on the servers and send the info out as it might cause issues if a server wasn't contactable.You might also look at a monitoring product.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2013-01-04 : 09:56:31
|
| my client is not ready to buy a monitoring product |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2013-01-09 : 01:09:20
|
| Hi Team,No one has implemented this in your environment? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2013-01-11 : 14:28:25
|
quote:
Originally posted by DBA007
Hi Team,I need a help for the below1.sqldatabase backup job failures from all serversCheck for msdb.Sys.sysjobs2.diskspace utilization from all serversYou can create linked server for all and query xp_fixeddrives store it in table3.Logspace utilization from all serversDo you different drive for logspaceThese need to be generated as single Excel file and send to mailid everday
|
|
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-01-15 : 08:44:19
|
| Hi DBA007,If all the servers are on the same network domain, you can use sqlcmd to generate a single csv file or excel file and send email.Thanks,Sridhar. |
|
|
|
|
|
|
health report