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  | 
                             
                            
                                    | 
                                         usafelix 
                                        Posting Yak  Master 
                                         
                                        
                                        165 Posts  | 
                                        
                                        
                                            
                                            
                                             Posted - 2014-08-28 : 04:49:19
                                            
  | 
                                             
                                            
                                            | Anyone have idea what kind of tools is easily to run the sql query result and auto save result file with allow set the time schedule to submit this query result by email to other users ? | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     ahmeds08 
                                    Aged Yak Warrior 
                                     
                                    
                                    737 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2014-08-28 : 04:58:57
                                          
  | 
                                         
                                        
                                          | one of the options is to use SSRS and subscribe the reportsJaveed Ahmed  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     usafelix 
                                    Posting Yak  Master 
                                     
                                    
                                    165 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2014-08-28 : 06:14:01
                                          
  | 
                                         
                                        
                                          | Have any freeware tools ?  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     suvendupatra 
                                    Starting Member 
                                     
                                    
                                    1 Post  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2014-09-04 : 03:06:35
                                          
  | 
                                         
                                        
                                          | Use sqlcmd command to execute, email, save the result and can schedule using windows at command  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     pkrana1980 
                                    Starting Member 
                                     
                                    
                                    3 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2014-09-05 : 12:33:32
                                          
  | 
                                         
                                        
                                          | you can do it using powershell or using SSRS as described earlier.  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |