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 |
|
kwilliams
194 Posts |
 Posted - 2004-03-16 : 15:18:06
|
I've created 2 views that I'll call dbo.EA and dbo.EJ, and then 3 queries that pulls different data from these 2 views. What I need to do is the following:1) Create "ALTER VIEW" Stored Procedure to pull the most up-to-date data. This is what I have so far:USE [SERVERNAME]GOALTER VIEW [Employment_App_VIEW]AS SELECT [dbo].[TABLENAME].[KEY], [dbo].[TABLENAME].[COLUMNS]FROM [dbo].[TABLENAME] 2) Run 3 Stored Procedures.3) Email the results of these 3 jobs to 2 fellow employees.Is there a way of setting this up completely in SQL Server? If so, how should I go about this? I'd like to create one job that handles all of these tasks once a day at 4:30pm., but I'm just not sure about how to set up the emailing of reports in SQL Server. Thanks for any help.KWilliams |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-16 : 16:17:36
|
| Do you have SQL Mail configured?I don't understand the purpose of altering the view. Could you explain this? You just select from the view to get the data. You don't alter it.Tara |
 |
|
|
|
|
|
Setting up job to email query results...