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 |
|
kallushashi
Starting Member
11 Posts |
 Posted - 2012-10-24 : 10:09:12
|
| Hi All, i am facing a problem like i am having a 4 scripts for monitoring sql server like Script to check drive free space,Script to check backupstatus,Script to check databasestatus,Script to check unsuccessful jobs.And my problem is i want this all script reult in one mail can any one help me please it's urgent pleaseshashi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-24 : 10:21:31
|
| place each of results on to a temporary table with category to denote the type like disk space,backupststs etc. then use sp_send_dbmail and give select query from this table to include unified results in the mail------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kallushashi
Starting Member
11 Posts |
Posted - 2012-10-24 : 10:24:01
|
| Actualy i need the following script to run every day on scheduled time and result to be mailed to the particular persons please give me the exact solution with step by step as i am new to sql server pleaseshashi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-24 : 10:31:50
|
quote:
Originally posted by kallushashi
Actualy i need the following script to run every day on scheduled time and result to be mailed to the particular persons please give me the exact solution with step by step as i am new to sql server pleaseshashi
put it as a step in sql server agent job and schedule it to execute daily as per your schedule------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
kallushashi
Starting Member
11 Posts |
Posted - 2012-10-25 : 09:50:21
|
| Can you explain in detail as i told you i am new to sql servershashi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
kallushashi
Starting Member
11 Posts |
Posted - 2012-10-25 : 10:59:25
|
| By that process the script scheduled for mentioned time i want the script to be executed and result to be mailedshashi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 11:21:03
|
quote:
Originally posted by kallushashi
By that process the script scheduled for mentioned time i want the script to be executed and result to be mailedshashi
it will schedule and execute it automaticallyfor mail part you need to use sp_dend_dbmail as i suggested beforehttp://msdn.microsoft.com/en-us/library/ms190307.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Need multiple Script result in one mail