Hello:
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. Is
there a way to place syntax in the script to pull the date from the operating
system?
Thanks!
childofthe1980s> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in 2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
Most probably (can't say for sure without knowing anything about your code). Check out the GETDATE()
function.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
> Thanks!
> childofthe1980s|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
Showing posts with label e-mail. Show all posts
Showing posts with label e-mail. Show all posts
Monday, March 26, 2012
e-mailing users in SQL 2000
Hello:
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. Is
there a way to place syntax in the script to pull the date from the operating
system?
Thanks!
childofthe1980s
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in 2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
Most probably (can't say for sure without knowing anything about your code). Check out the GETDATE()
function.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
> Thanks!
> childofthe1980s
|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. Is
there a way to place syntax in the script to pull the date from the operating
system?
Thanks!
childofthe1980s
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in 2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
Most probably (can't say for sure without knowing anything about your code). Check out the GETDATE()
function.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06. I
> don't want the IT staff to have to come in and update the date parameter. Is
> there a way to place syntax in the script to pull the date from the operating
> system?
> Thanks!
> childofthe1980s
|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
e-mailing users in SQL 2000
Hello:
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. I
s
there a way to place syntax in the script to pull the date from the operatin
g
system?
Thanks!
childofthe1980s> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in
2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
Most probably (can't say for sure without knowing anything about your code).
Check out the GETDATE()
function.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in messa
ge
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, invento
ry
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
> Thanks!
> childofthe1980s|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
Two questions.
First, generally speaking, how do you configure SQL 2000 to e-mail end
users? I have a SQL script that shows, in an accounting database, inventory
items that have not been purchased from a vendor within the last year. I
want to e-mail that list of items to end users on a monthly basis. That
list of items amounts to a report.
Secondly, my script has a specific date. It, basically, says < 06/01/06. I
don't want the IT staff to have to come in and update the date parameter. I
s
there a way to place syntax in the script to pull the date from the operatin
g
system?
Thanks!
childofthe1980s> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users?
I suggest you use xp_smtp from www.sqldev.net. The built-in email support in
2000 is based on MAPI
and is a hassle to get working.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
Most probably (can't say for sure without knowing anything about your code).
Check out the GETDATE()
function.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in messa
ge
news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database, invento
ry
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
I
> don't want the IT staff to have to come in and update the date parameter.
Is
> there a way to place syntax in the script to pull the date from the operat
ing
> system?
> Thanks!
> childofthe1980s|||Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:273474B7-38E8-435F-835A-123502316C07@.microsoft.com...
> Hello:
> Two questions.
> First, generally speaking, how do you configure SQL 2000 to e-mail end
> users? I have a SQL script that shows, in an accounting database,
> inventory
> items that have not been purchased from a vendor within the last year. I
> want to e-mail that list of items to end users on a monthly basis. That
> list of items amounts to a report.
> Secondly, my script has a specific date. It, basically, says < 06/01/06.
> I
> don't want the IT staff to have to come in and update the date parameter.
> Is
> there a way to place syntax in the script to pull the date from the
> operating
> system?
> Thanks!
> childofthe1980s
e-mailing reports and refreshing reports automatically
Hello:
I know that you can e-mail SQL Reporting Services reports. But, can the
reports be configured to refresh their data automatically and be e-mailed to
users automatically with the refreshed data?
Or, would someone have to go into SQL Reporting Services, manually refresh,
and manually e-mail the reports?
Thanks!
childofthe1980sOrdinarily, this is automatic. Unless you tell a report to pull from a
stored snapshot, it is running your queries and re-pulling the data
automatically each time the report is run...
Maybe I misunderstand your question?
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> Hello:
> I know that you can e-mail SQL Reporting Services reports. But, can the
> reports be configured to refresh their data automatically and be e-mailed
> to
> users automatically with the refreshed data?
> Or, would someone have to go into SQL Reporting Services, manually
> refresh,
> and manually e-mail the reports?
> Thanks!
> childofthe1980s|||Well, what I meant is have SQL refresh reports and e-mail the results
automatically behind the scenes without user intervention.
Thanks!
childofthe1980s
"Lisa Slater Nicholls" wrote:
> Ordinarily, this is automatic. Unless you tell a report to pull from a
> stored snapshot, it is running your queries and re-pulling the data
> automatically each time the report is run...
> Maybe I misunderstand your question?
> >L<
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> > Hello:
> >
> > I know that you can e-mail SQL Reporting Services reports. But, can the
> > reports be configured to refresh their data automatically and be e-mailed
> > to
> > users automatically with the refreshed data?
> >
> > Or, would someone have to go into SQL Reporting Services, manually
> > refresh,
> > and manually e-mail the reports?
> >
> > Thanks!
> >
> > childofthe1980s
>|||Then, like I said, this is the way it works <s>. You don't have to
"intervene". Unless you *told* the report to hold a static snapshot, it
*always* pulls the data live, at each subscription run instance.
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:8BDC82B6-1B23-452E-A01A-4730069AEF60@.microsoft.com...
> Well, what I meant is have SQL refresh reports and e-mail the results
> automatically behind the scenes without user intervention.
> Thanks!
> childofthe1980s
> "Lisa Slater Nicholls" wrote:
>> Ordinarily, this is automatic. Unless you tell a report to pull from a
>> stored snapshot, it is running your queries and re-pulling the data
>> automatically each time the report is run...
>> Maybe I misunderstand your question?
>> >L<
>> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
>> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
>> > Hello:
>> >
>> > I know that you can e-mail SQL Reporting Services reports. But, can
>> > the
>> > reports be configured to refresh their data automatically and be
>> > e-mailed
>> > to
>> > users automatically with the refreshed data?
>> >
>> > Or, would someone have to go into SQL Reporting Services, manually
>> > refresh,
>> > and manually e-mail the reports?
>> >
>> > Thanks!
>> >
>> > childofthe1980s
>>
I know that you can e-mail SQL Reporting Services reports. But, can the
reports be configured to refresh their data automatically and be e-mailed to
users automatically with the refreshed data?
Or, would someone have to go into SQL Reporting Services, manually refresh,
and manually e-mail the reports?
Thanks!
childofthe1980sOrdinarily, this is automatic. Unless you tell a report to pull from a
stored snapshot, it is running your queries and re-pulling the data
automatically each time the report is run...
Maybe I misunderstand your question?
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> Hello:
> I know that you can e-mail SQL Reporting Services reports. But, can the
> reports be configured to refresh their data automatically and be e-mailed
> to
> users automatically with the refreshed data?
> Or, would someone have to go into SQL Reporting Services, manually
> refresh,
> and manually e-mail the reports?
> Thanks!
> childofthe1980s|||Well, what I meant is have SQL refresh reports and e-mail the results
automatically behind the scenes without user intervention.
Thanks!
childofthe1980s
"Lisa Slater Nicholls" wrote:
> Ordinarily, this is automatic. Unless you tell a report to pull from a
> stored snapshot, it is running your queries and re-pulling the data
> automatically each time the report is run...
> Maybe I misunderstand your question?
> >L<
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> > Hello:
> >
> > I know that you can e-mail SQL Reporting Services reports. But, can the
> > reports be configured to refresh their data automatically and be e-mailed
> > to
> > users automatically with the refreshed data?
> >
> > Or, would someone have to go into SQL Reporting Services, manually
> > refresh,
> > and manually e-mail the reports?
> >
> > Thanks!
> >
> > childofthe1980s
>|||Then, like I said, this is the way it works <s>. You don't have to
"intervene". Unless you *told* the report to hold a static snapshot, it
*always* pulls the data live, at each subscription run instance.
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:8BDC82B6-1B23-452E-A01A-4730069AEF60@.microsoft.com...
> Well, what I meant is have SQL refresh reports and e-mail the results
> automatically behind the scenes without user intervention.
> Thanks!
> childofthe1980s
> "Lisa Slater Nicholls" wrote:
>> Ordinarily, this is automatic. Unless you tell a report to pull from a
>> stored snapshot, it is running your queries and re-pulling the data
>> automatically each time the report is run...
>> Maybe I misunderstand your question?
>> >L<
>> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
>> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
>> > Hello:
>> >
>> > I know that you can e-mail SQL Reporting Services reports. But, can
>> > the
>> > reports be configured to refresh their data automatically and be
>> > e-mailed
>> > to
>> > users automatically with the refreshed data?
>> >
>> > Or, would someone have to go into SQL Reporting Services, manually
>> > refresh,
>> > and manually e-mail the reports?
>> >
>> > Thanks!
>> >
>> > childofthe1980s
>>
Thursday, March 22, 2012
E-Mail User When StoredProc Fails
Hi,
I want to e-mail a user when a Stored Proc fails, what is the best way to do this? I was going to create a DTS package or is this too complicated?
Also, the Stored Proc inserts data from one table to another, I would like to use Transactions so that if this fails it rolls back to where it was, I'm not sure of the best way to go about this. Could anyone possibly point me in the right direction? Here's a copy of some of the stored procedure to give an idea of what I am doing:
-- insert data into proper tables with extract date added
INSERT INTO tbl_Surgery
SELECT
SurgeryKey,
GETDATE(),
ClinicianCode,
StartTime,
SessionGroup,
[Description],
SurgeryName,
Deleted,
PremisesKey,
@.practiceCode --SUBSTRING(SurgeryKey,PATINDEX('%.%',SurgeryKey)+1, 5)
FROM tbl_SurgeryIn
INSERT INTO tbl_SurgerySlot
SELECT
SurgerySlotKey,
GETDATE(),
SurgeryKey,
Length,
Deleted,
StartTime,
RestrictionDays,
Label,
IsRestricted,
@.practiceCode
FROM tbl_SurgerySlotIn
INSERT INTO tbl_Appointment
SELECT
AppointmentKey,
GETDATE(),
SurgerySlotKey,
PatientKey,
Cancelled,
Continuation,
Deleted,
Reason,
DateMade
FROM tbl_AppointmentIn
-- empty input tables
DELETE FROM tbl_SurgeryIn
DELETE FROM tbl_SurgerySlotIn
DELETE FROM tbl_AppointmentIn
Any help would me very much appreciated,
ThanksSomething like this should work:
CREATE PROCEDURE ProcName
AS
BEGIN TRANSACTION transaction_1
DECLARE @.error_handle VARCHAR(255)
-- insert data into proper tables with extract date added
INSERT INTO tbl_Surgery
SELECT
SurgeryKey,
GETDATE(),
ClinicianCode,
StartTime,
SessionGroup,
[Description],
SurgeryName,
Deleted,
PremisesKey,
@.practiceCode --SUBSTRING(SurgeryKey,PATINDEX('%.%',SurgeryKey)+1, 5)
FROM tbl_SurgeryIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_Surgery insert.'
GOTO error_handle
END
INSERT INTO tbl_SurgerySlot
SELECT
SurgerySlotKey,
GETDATE(),
SurgeryKey,
Length,
Deleted,
StartTime,
RestrictionDays,
Label,
IsRestricted,
@.practiceCode
FROM tbl_SurgerySlotIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_SurgerySlot insert.'
GOTO error_handle
END
INSERT INTO tbl_Appointment
SELECT
AppointmentKey,
GETDATE(),
SurgerySlotKey,
PatientKey,
Cancelled,
Continuation,
Deleted,
Reason,
DateMade
FROM tbl_AppointmentIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_Appointment insert.'
GOTO error_handle
END
-- empty input tables
DELETE FROM tbl_SurgeryIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_Surgery delete.'
GOTO error_handle
END
DELETE FROM tbl_SurgerySlotIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_SurgerySlotIn delete.'
GOTO error_handle
END
DELETE FROM tbl_AppointmentIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_AppointmentIn delete.'
GOTO error_handle
END
end_procedure:
COMMIT TRANSACTION transaction_1 --Commits transactions if no errors occurred.
RETURN 0 --Indicates succcess.
error_handle
ROLLBACK TRANSACTION transaction_1
RAISERROR(@.error_handle,16,1)
EXEC xp_sendmail 'user@.mail.com',@.error_handle
RETURN 1
Alternately, if you are running this from a job, you can strip out the xp_sendmail and just have it send email on failure. The RETURN 1 with the RAISERROR will indicate failure.|||I would strongly suggest creating a job to run the stored procedure, and having the job email you on failure. It is easy to do, and relatively foolproof!
-PatP|||Thanks, that's great, I'll give it a go. So the RAISERROR and RETURN 1 are just a way of letting SQL know that the procedure has failed??
The only thing I'm confused/worried about is the best place to put the BEGIN TRANSACTION and the end_procedure code. The stored procedure I've inherited has rather a lot of BEGINS/ENDS so I'm worried about confusing it, here's a copy of the original, any indication you could give me would really help:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE sproc_48hrAccess_Upload
AS
SET DATEFORMAT dmy
DECLARE @.practiceCode char(5)
DECLARE @.server varchar(255)
DECLARE @.inPath varchar(255)
DECLARE @.archiveBase varchar(255)
DECLARE @.archivePath varchar(255)
DECLARE @.zipPath varchar(255)
DECLARE @.cmdshell varchar(255)
DECLARE @.result int
DECLARE @.date varchar(10)
SET @.server = 'MURDOCH'
SET @.inPath = 'E:\48hrAccess\48hrDataIn\'
SET @.archiveBase = 'E:\48hrAccess\48hrDataArchive\'
SET @.zipPath = 'C:\Progra~1\WinZip\' --C:\Program Files\Winzip\
SET @.date = CONVERT(varchar(2),DATEPART(dd,GETDATE()))+CONVERT (varchar(2),DATEPART(mm,GETDATE()))+CONVERT(char(4 ),DATEPART(yy,GETDATE()))
-- upload for each practice in tbl_Practice
DECLARE allPractices CURSOR LOCAL FORWARD_ONLY READ_ONLY FOR SELECT practiceCode FROM tbl_Practice
OPEN allPractices
FETCH NEXT FROM allPractices INTO @.practiceCode
WHILE @.@.FETCH_STATUS = 0
BEGIN
SET @.archivePath = @.archiveBase+@.practiceCode+'\'
-- copy files into archive folder
SET @.cmdshell = 'MOVE '+@.inPath+'48hr_'+@.practiceCode+'_'+@.date+'.zip '+@.archivePath
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- unzip file
SET @.cmdshell = @.zipPath+'WZUNZIP -ybc -o -sPASSWORD '+@.archivePath+'48hr_'+@.practiceCode+'_'+@.date+'.z ip '+@.archivePath
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- copy data files into upload tables
SET @.cmdshell = 'ECHO ** BEGIN Upload '+CONVERT(varchar,GETDATE())+' ******************************* >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'ECHO xv_Surgery.dat >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'bcp GMS_48hrAccess..tbl_SurgeryIn in '+@.archivePath+'xv_Surgery.dat -n -V65 -t"||" -r"|||\n" -S'+@.server+' -T >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'ECHO xv_SurgerySlot.dat >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'bcp GMS_48hrAccess..tbl_SurgerySlotIn in '+@.archivePath+'xv_SurgerySlot.dat -n -V65 -t"||" -r"|||\n" -S'+@.server+' -T >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'ECHO xv_Appointment.dat >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'bcp GMS_48hrAccess..tbl_AppointmentIn in '+@.archivePath+'xv_Appointment.dat -n -V65 -t"||" -r"|||\n" -S'+@.server+' -T >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- clean up
SET @.cmdshell = 'DEL /F '+@.archivePath+'*.dat '+@.archivePath+'48hrAccess.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- update tbl_SurgerySlotDescription (will fire trigger if new labels appear)
INSERT INTO tbl_SurgerySlotDescription
SELECT DISTINCT @.practiceCode, ssi.Label, ssi.AutoFillMessage, ssi.IsBookable, null
FROM tbl_SurgerySlotIn ssi
WHERE SUBSTRING(ssi.SurgerySlotKey,PATINDEX('%.%',ssi.Su rgerySlotKey)+1,5) = @.practiceCode
AND ssi.Label NOT IN (
SELECT Label
FROM tbl_SurgerySlotDescription
WHERE PracticeCode = @.practiceCode
)
-- insert data into proper tables with extract date added
INSERT INTO tbl_Surgery
SELECT
SurgeryKey,
GETDATE(),
ClinicianCode,
StartTime,
SessionGroup,
[Description],
SurgeryName,
Deleted,
PremisesKey,
@.practiceCode --SUBSTRING(SurgeryKey,PATINDEX('%.%',SurgeryKey)+1, 5)
FROM tbl_SurgeryIn
INSERT INTO tbl_SurgerySlot
SELECT
SurgerySlotKey,
GETDATE(),
SurgeryKey,
Length,
Deleted,
StartTime,
RestrictionDays,
Label,
IsRestricted,
@.practiceCode
FROM tbl_SurgerySlotIn
INSERT INTO tbl_Appointment
SELECT
AppointmentKey,
GETDATE(),
SurgerySlotKey,
PatientKey,
Cancelled,
Continuation,
Deleted,
Reason,
DateMade
FROM tbl_AppointmentIn
-- empty input tables
DELETE FROM tbl_SurgeryIn
DELETE FROM tbl_SurgerySlotIn
DELETE FROM tbl_AppointmentIn
FETCH NEXT FROM allPractices INTO @.practiceCode
END
CLOSE allPractices
DEALLOCATE allPractices
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
I want to e-mail a user when a Stored Proc fails, what is the best way to do this? I was going to create a DTS package or is this too complicated?
Also, the Stored Proc inserts data from one table to another, I would like to use Transactions so that if this fails it rolls back to where it was, I'm not sure of the best way to go about this. Could anyone possibly point me in the right direction? Here's a copy of some of the stored procedure to give an idea of what I am doing:
-- insert data into proper tables with extract date added
INSERT INTO tbl_Surgery
SELECT
SurgeryKey,
GETDATE(),
ClinicianCode,
StartTime,
SessionGroup,
[Description],
SurgeryName,
Deleted,
PremisesKey,
@.practiceCode --SUBSTRING(SurgeryKey,PATINDEX('%.%',SurgeryKey)+1, 5)
FROM tbl_SurgeryIn
INSERT INTO tbl_SurgerySlot
SELECT
SurgerySlotKey,
GETDATE(),
SurgeryKey,
Length,
Deleted,
StartTime,
RestrictionDays,
Label,
IsRestricted,
@.practiceCode
FROM tbl_SurgerySlotIn
INSERT INTO tbl_Appointment
SELECT
AppointmentKey,
GETDATE(),
SurgerySlotKey,
PatientKey,
Cancelled,
Continuation,
Deleted,
Reason,
DateMade
FROM tbl_AppointmentIn
-- empty input tables
DELETE FROM tbl_SurgeryIn
DELETE FROM tbl_SurgerySlotIn
DELETE FROM tbl_AppointmentIn
Any help would me very much appreciated,
ThanksSomething like this should work:
CREATE PROCEDURE ProcName
AS
BEGIN TRANSACTION transaction_1
DECLARE @.error_handle VARCHAR(255)
-- insert data into proper tables with extract date added
INSERT INTO tbl_Surgery
SELECT
SurgeryKey,
GETDATE(),
ClinicianCode,
StartTime,
SessionGroup,
[Description],
SurgeryName,
Deleted,
PremisesKey,
@.practiceCode --SUBSTRING(SurgeryKey,PATINDEX('%.%',SurgeryKey)+1, 5)
FROM tbl_SurgeryIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_Surgery insert.'
GOTO error_handle
END
INSERT INTO tbl_SurgerySlot
SELECT
SurgerySlotKey,
GETDATE(),
SurgeryKey,
Length,
Deleted,
StartTime,
RestrictionDays,
Label,
IsRestricted,
@.practiceCode
FROM tbl_SurgerySlotIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_SurgerySlot insert.'
GOTO error_handle
END
INSERT INTO tbl_Appointment
SELECT
AppointmentKey,
GETDATE(),
SurgerySlotKey,
PatientKey,
Cancelled,
Continuation,
Deleted,
Reason,
DateMade
FROM tbl_AppointmentIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_Appointment insert.'
GOTO error_handle
END
-- empty input tables
DELETE FROM tbl_SurgeryIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_Surgery delete.'
GOTO error_handle
END
DELETE FROM tbl_SurgerySlotIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_SurgerySlotIn delete.'
GOTO error_handle
END
DELETE FROM tbl_AppointmentIn
IF @.@.ERROR <> 0
BEGIN
SELECT @.error_handle = 'ProcName::Failure on tbl_AppointmentIn delete.'
GOTO error_handle
END
end_procedure:
COMMIT TRANSACTION transaction_1 --Commits transactions if no errors occurred.
RETURN 0 --Indicates succcess.
error_handle
ROLLBACK TRANSACTION transaction_1
RAISERROR(@.error_handle,16,1)
EXEC xp_sendmail 'user@.mail.com',@.error_handle
RETURN 1
Alternately, if you are running this from a job, you can strip out the xp_sendmail and just have it send email on failure. The RETURN 1 with the RAISERROR will indicate failure.|||I would strongly suggest creating a job to run the stored procedure, and having the job email you on failure. It is easy to do, and relatively foolproof!
-PatP|||Thanks, that's great, I'll give it a go. So the RAISERROR and RETURN 1 are just a way of letting SQL know that the procedure has failed??
The only thing I'm confused/worried about is the best place to put the BEGIN TRANSACTION and the end_procedure code. The stored procedure I've inherited has rather a lot of BEGINS/ENDS so I'm worried about confusing it, here's a copy of the original, any indication you could give me would really help:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE sproc_48hrAccess_Upload
AS
SET DATEFORMAT dmy
DECLARE @.practiceCode char(5)
DECLARE @.server varchar(255)
DECLARE @.inPath varchar(255)
DECLARE @.archiveBase varchar(255)
DECLARE @.archivePath varchar(255)
DECLARE @.zipPath varchar(255)
DECLARE @.cmdshell varchar(255)
DECLARE @.result int
DECLARE @.date varchar(10)
SET @.server = 'MURDOCH'
SET @.inPath = 'E:\48hrAccess\48hrDataIn\'
SET @.archiveBase = 'E:\48hrAccess\48hrDataArchive\'
SET @.zipPath = 'C:\Progra~1\WinZip\' --C:\Program Files\Winzip\
SET @.date = CONVERT(varchar(2),DATEPART(dd,GETDATE()))+CONVERT (varchar(2),DATEPART(mm,GETDATE()))+CONVERT(char(4 ),DATEPART(yy,GETDATE()))
-- upload for each practice in tbl_Practice
DECLARE allPractices CURSOR LOCAL FORWARD_ONLY READ_ONLY FOR SELECT practiceCode FROM tbl_Practice
OPEN allPractices
FETCH NEXT FROM allPractices INTO @.practiceCode
WHILE @.@.FETCH_STATUS = 0
BEGIN
SET @.archivePath = @.archiveBase+@.practiceCode+'\'
-- copy files into archive folder
SET @.cmdshell = 'MOVE '+@.inPath+'48hr_'+@.practiceCode+'_'+@.date+'.zip '+@.archivePath
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- unzip file
SET @.cmdshell = @.zipPath+'WZUNZIP -ybc -o -sPASSWORD '+@.archivePath+'48hr_'+@.practiceCode+'_'+@.date+'.z ip '+@.archivePath
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- copy data files into upload tables
SET @.cmdshell = 'ECHO ** BEGIN Upload '+CONVERT(varchar,GETDATE())+' ******************************* >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'ECHO xv_Surgery.dat >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'bcp GMS_48hrAccess..tbl_SurgeryIn in '+@.archivePath+'xv_Surgery.dat -n -V65 -t"||" -r"|||\n" -S'+@.server+' -T >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'ECHO xv_SurgerySlot.dat >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'bcp GMS_48hrAccess..tbl_SurgerySlotIn in '+@.archivePath+'xv_SurgerySlot.dat -n -V65 -t"||" -r"|||\n" -S'+@.server+' -T >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'ECHO xv_Appointment.dat >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
SET @.cmdshell = 'bcp GMS_48hrAccess..tbl_AppointmentIn in '+@.archivePath+'xv_Appointment.dat -n -V65 -t"||" -r"|||\n" -S'+@.server+' -T >> '+@.archivePath+'48hrUpload.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- clean up
SET @.cmdshell = 'DEL /F '+@.archivePath+'*.dat '+@.archivePath+'48hrAccess.log'
EXEC master..xp_cmdshell @.cmdshell, NO_OUTPUT
-- update tbl_SurgerySlotDescription (will fire trigger if new labels appear)
INSERT INTO tbl_SurgerySlotDescription
SELECT DISTINCT @.practiceCode, ssi.Label, ssi.AutoFillMessage, ssi.IsBookable, null
FROM tbl_SurgerySlotIn ssi
WHERE SUBSTRING(ssi.SurgerySlotKey,PATINDEX('%.%',ssi.Su rgerySlotKey)+1,5) = @.practiceCode
AND ssi.Label NOT IN (
SELECT Label
FROM tbl_SurgerySlotDescription
WHERE PracticeCode = @.practiceCode
)
-- insert data into proper tables with extract date added
INSERT INTO tbl_Surgery
SELECT
SurgeryKey,
GETDATE(),
ClinicianCode,
StartTime,
SessionGroup,
[Description],
SurgeryName,
Deleted,
PremisesKey,
@.practiceCode --SUBSTRING(SurgeryKey,PATINDEX('%.%',SurgeryKey)+1, 5)
FROM tbl_SurgeryIn
INSERT INTO tbl_SurgerySlot
SELECT
SurgerySlotKey,
GETDATE(),
SurgeryKey,
Length,
Deleted,
StartTime,
RestrictionDays,
Label,
IsRestricted,
@.practiceCode
FROM tbl_SurgerySlotIn
INSERT INTO tbl_Appointment
SELECT
AppointmentKey,
GETDATE(),
SurgerySlotKey,
PatientKey,
Cancelled,
Continuation,
Deleted,
Reason,
DateMade
FROM tbl_AppointmentIn
-- empty input tables
DELETE FROM tbl_SurgeryIn
DELETE FROM tbl_SurgerySlotIn
DELETE FROM tbl_AppointmentIn
FETCH NEXT FROM allPractices INTO @.practiceCode
END
CLOSE allPractices
DEALLOCATE allPractices
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Email Subscriptions Issue
Hi,
I've been having an issue getting email subscriptions going. I've followed
the link on Configure a Report Server for E-mail Delivery on msdn2 and it
looks like it creates the report, I'm just getting an odd CAS issue I don't
know how to resolve.
Here is the info from my log
ReportingServicesService!schedule!4!3/21/2006-08:30:01:: Creating Time based
subscription notification for subscription:
c2ab0c2a-b6f1-4778-bd8a-f095d11a04b8
ReportingServicesService!library!4!3/21/2006-08:30:01:: Schedule
b91a6628-784f-4c47-853d-8a589c2a6879 execution completed at 3/21/2006
8:30:01 AM.
ReportingServicesService!dbpolling!4!3/21/2006-08:30:01:: EventPolling
finished processing item 67befaa3-5171-4991-b84e-61c064c1a5ed
ReportingServicesService!dbpolling!c!3/21/2006-08:30:01::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!d!3/21/2006-08:30:01::
NotificationPolling processing item 3b191c1b-5df5-42ee-9ed1-6437e7c68d90
ReportingServicesService!notification!d!03/21/2006-08:30:01:: e ERROR: Error
occured processing notification. Request for the permission of type
'System.Web.AspNetHostingPermission, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
ReportingServicesService!notification!d!03/21/2006-08:30:01:: Notification
3b191c1b-5df5-42ee-9ed1-6437e7c68d90 completed. Success: True, Status:
Request for the permission of type 'System.Web.AspNetHostingPermission,
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
failed., DeliveryExtension: Report Server Email, Report: SalesOrderSummary,
Attempt 0
ReportingServicesService!dbpolling!d!03/21/2006-08:30:01::
NotificationPolling finished processing item
3b191c1b-5df5-42ee-9ed1-6437e7c68d90
I've searched for the AspNetHostingPermission regards to this, but can't
seem to find it. I set an unattended execution account but no good there.
do I have to give whatever account the ReportingServiceServices is running
as AspNetHostingPermission access? And to what?
Thanks,
ChrisHi Chris,
Welcome to the MSDN newsgroup.
From your description, I understand you're encounering some problem in the
SQL 2005 reporting service when use the email delivery service to send
email notification, correct?
Based on the log entry you provided, the reporting service application is
concerning about the ASPNETHostPermission, this is quite strange and I
seldom see error on this object,(mostly it'll report error regarding on a
certain account or an API call...).
I think we can first try confirming this issue to be a .NET cas specific
one. You can use the "caspol.exe" tool(shiped with .net framework to
configure .NET code access policy setting)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
the SSRS email delivery again under the CAS disabing mode to see whether it
still suffer the issue. If not, we can confirm the problem to be a .net CAS
configration or code evidence specifc issue.
Also, you can try creating another SSRS report and configure it to use
EMAIL delivery to see whethre this is a common problem on that server
machine.
In addition, here are some reference introducing the .NET CAS used in SQL
2005 reporting service:
#Understanding Code Access Security in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms155108.aspx
Please feel free to post here if you've any other finding.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thanks for the response. So I ran caspol -s off which temporarily disabled
CAS checking. Ran the subscription and no dice. I tried running it as a
file share, same error as before with the ASPNetHostingPermission.
When you talk about creating a report for email delivery, what exactly do
you mean. I'm afraid I'm not sure what to do here.
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:I9pOSMYTGHA.7884@.TK2MSFTNGXA03.phx.gbl...
> Hi Chris,
> Welcome to the MSDN newsgroup.
> From your description, I understand you're encounering some problem in the
> SQL 2005 reporting service when use the email delivery service to send
> email notification, correct?
> Based on the log entry you provided, the reporting service application is
> concerning about the ASPNETHostPermission, this is quite strange and I
> seldom see error on this object,(mostly it'll report error regarding on a
> certain account or an API call...).
> I think we can first try confirming this issue to be a .NET cas specific
> one. You can use the "caspol.exe" tool(shiped with .net framework to
> configure .NET code access policy setting)
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
> l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
>
> use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
> the SSRS email delivery again under the CAS disabing mode to see whether
> it
> still suffer the issue. If not, we can confirm the problem to be a .net
> CAS
> configration or code evidence specifc issue.
> Also, you can try creating another SSRS report and configure it to use
> EMAIL delivery to see whethre this is a common problem on that server
> machine.
> In addition, here are some reference introducing the .NET CAS used in SQL
> 2005 reporting service:
> #Understanding Code Access Security in Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms155108.aspx
> Please feel free to post here if you've any other finding.
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your response Chris,
So turn off CAS still suffer the problem, it is likely not a typical CAS
configuration issue. The "creating a report for email delivery" I mentioned
means create another report or a new email notification task to see whether
it also suffers the problem.
BTW, does this problem occur the first time on that server and have you
ever successfully used the email notification on that server before?
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may
learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
I tried creating a new report with new email delvery options. Same result.
No, I have never used email delivery on this before, so I've never had a
successful run of it.
What else can I check?
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may
> learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||To add to this I'm using Forms Auth. However, running in debug mode and
letting the server execute doesn't ever hit any breakpoints...
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may
> learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your followup Chris,
Since the email delivery never run on the server, I'm thinking whether
there is something incorrectly about the RS installation. Is it possible
that you try unstalling and reinstalling the RS service?
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thank you for the continued assistance. I've decided to escalate this to an
MSDN support incident since it seems to be much more than meets the eye.
To answer your question though, it's happening on 3 different servers with
RS on it. Each one same issue.
Thank you so much for your continued support though!
-Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:Z6ib5%23lUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
> Thanks for your followup Chris,
> Since the email delivery never run on the server, I'm thinking whether
> there is something incorrectly about the RS installation. Is it possible
> that you try unstalling and reinstalling the RS service?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your response Chris,
Hope you'll soon get this resolved. And welcome to post the result and
share with us when you got it resolved.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.sql
I've been having an issue getting email subscriptions going. I've followed
the link on Configure a Report Server for E-mail Delivery on msdn2 and it
looks like it creates the report, I'm just getting an odd CAS issue I don't
know how to resolve.
Here is the info from my log
ReportingServicesService!schedule!4!3/21/2006-08:30:01:: Creating Time based
subscription notification for subscription:
c2ab0c2a-b6f1-4778-bd8a-f095d11a04b8
ReportingServicesService!library!4!3/21/2006-08:30:01:: Schedule
b91a6628-784f-4c47-853d-8a589c2a6879 execution completed at 3/21/2006
8:30:01 AM.
ReportingServicesService!dbpolling!4!3/21/2006-08:30:01:: EventPolling
finished processing item 67befaa3-5171-4991-b84e-61c064c1a5ed
ReportingServicesService!dbpolling!c!3/21/2006-08:30:01::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!d!3/21/2006-08:30:01::
NotificationPolling processing item 3b191c1b-5df5-42ee-9ed1-6437e7c68d90
ReportingServicesService!notification!d!03/21/2006-08:30:01:: e ERROR: Error
occured processing notification. Request for the permission of type
'System.Web.AspNetHostingPermission, System, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
ReportingServicesService!notification!d!03/21/2006-08:30:01:: Notification
3b191c1b-5df5-42ee-9ed1-6437e7c68d90 completed. Success: True, Status:
Request for the permission of type 'System.Web.AspNetHostingPermission,
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
failed., DeliveryExtension: Report Server Email, Report: SalesOrderSummary,
Attempt 0
ReportingServicesService!dbpolling!d!03/21/2006-08:30:01::
NotificationPolling finished processing item
3b191c1b-5df5-42ee-9ed1-6437e7c68d90
I've searched for the AspNetHostingPermission regards to this, but can't
seem to find it. I set an unattended execution account but no good there.
do I have to give whatever account the ReportingServiceServices is running
as AspNetHostingPermission access? And to what?
Thanks,
ChrisHi Chris,
Welcome to the MSDN newsgroup.
From your description, I understand you're encounering some problem in the
SQL 2005 reporting service when use the email delivery service to send
email notification, correct?
Based on the log entry you provided, the reporting service application is
concerning about the ASPNETHostPermission, this is quite strange and I
seldom see error on this object,(mostly it'll report error regarding on a
certain account or an API call...).
I think we can first try confirming this issue to be a .NET cas specific
one. You can use the "caspol.exe" tool(shiped with .net framework to
configure .NET code access policy setting)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
the SSRS email delivery again under the CAS disabing mode to see whether it
still suffer the issue. If not, we can confirm the problem to be a .net CAS
configration or code evidence specifc issue.
Also, you can try creating another SSRS report and configure it to use
EMAIL delivery to see whethre this is a common problem on that server
machine.
In addition, here are some reference introducing the .NET CAS used in SQL
2005 reporting service:
#Understanding Code Access Security in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms155108.aspx
Please feel free to post here if you've any other finding.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thanks for the response. So I ran caspol -s off which temporarily disabled
CAS checking. Ran the subscription and no dice. I tried running it as a
file share, same error as before with the ASPNetHostingPermission.
When you talk about creating a report for email delivery, what exactly do
you mean. I'm afraid I'm not sure what to do here.
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:I9pOSMYTGHA.7884@.TK2MSFTNGXA03.phx.gbl...
> Hi Chris,
> Welcome to the MSDN newsgroup.
> From your description, I understand you're encounering some problem in the
> SQL 2005 reporting service when use the email delivery service to send
> email notification, correct?
> Based on the log entry you provided, the reporting service application is
> concerning about the ASPNETHostPermission, this is quite strange and I
> seldom see error on this object,(mostly it'll report error regarding on a
> certain account or an API call...).
> I think we can first try confirming this issue to be a .NET cas specific
> one. You can use the "caspol.exe" tool(shiped with .net framework to
> configure .NET code access policy setting)
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
> l/cpconusingcodeaccesssecuritypolicytoolcaspolexe.asp
>
> use the "caspol.exe -s off" to temporarly disable the CAS checking. Test
> the SSRS email delivery again under the CAS disabing mode to see whether
> it
> still suffer the issue. If not, we can confirm the problem to be a .net
> CAS
> configration or code evidence specifc issue.
> Also, you can try creating another SSRS report and configure it to use
> EMAIL delivery to see whethre this is a common problem on that server
> machine.
> In addition, here are some reference introducing the .NET CAS used in SQL
> 2005 reporting service:
> #Understanding Code Access Security in Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms155108.aspx
> Please feel free to post here if you've any other finding.
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your response Chris,
So turn off CAS still suffer the problem, it is likely not a typical CAS
configuration issue. The "creating a report for email delivery" I mentioned
means create another report or a new email notification task to see whether
it also suffers the problem.
BTW, does this problem occur the first time on that server and have you
ever successfully used the email notification on that server before?
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may
learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
I tried creating a new report with new email delvery options. Same result.
No, I have never used email delivery on this before, so I've never had a
successful run of it.
What else can I check?
Thanks!
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may
> learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||To add to this I'm using Forms Auth. However, running in debug mode and
letting the server execute doesn't ever hit any breakpoints...
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:eIzGbZnTGHA.864@.TK2MSFTNGXA03.phx.gbl...
> Thanks for your response Chris,
> So turn off CAS still suffer the problem, it is likely not a typical CAS
> configuration issue. The "creating a report for email delivery" I
> mentioned
> means create another report or a new email notification task to see
> whether
> it also suffers the problem.
> BTW, does this problem occur the first time on that server and have you
> ever successfully used the email notification on that server before?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may
> learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your followup Chris,
Since the email delivery never run on the server, I'm thinking whether
there is something incorrectly about the RS installation. Is it possible
that you try unstalling and reinstalling the RS service?
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thank you for the continued assistance. I've decided to escalate this to an
MSDN support incident since it seems to be much more than meets the eye.
To answer your question though, it's happening on 3 different servers with
RS on it. Each one same issue.
Thank you so much for your continued support though!
-Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:Z6ib5%23lUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
> Thanks for your followup Chris,
> Since the email delivery never run on the server, I'm thinking whether
> there is something incorrectly about the RS installation. Is it possible
> that you try unstalling and reinstalling the RS service?
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Thanks for your response Chris,
Hope you'll soon get this resolved. And welcome to post the result and
share with us when you got it resolved.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.sql
Email subscriptions
Hello all,
I am trying to get some email subscriptions setup and I keep getting the
message "The e-mail address of one or more recipients is not valid". The
email address is valid and I am not sure what the problem is. If I set the
email address to a local account name (i.e Administrator) the subscription
works and e-mail shows up in the drop folder of the smtp server. Does anyone
know how I can get my subscriptions working to real email addresses and not
just local accounts? Any help would be appreciated.
Thanks,
JeffI have solved my own issue. All I needed to do was edit the SMTP server
settings to grant access to the server to relay through its own IP address.
Jeff
"Jeff McIntire" wrote:
> Hello all,
> I am trying to get some email subscriptions setup and I keep getting the
> message "The e-mail address of one or more recipients is not valid". The
> email address is valid and I am not sure what the problem is. If I set the
> email address to a local account name (i.e Administrator) the subscription
> works and e-mail shows up in the drop folder of the smtp server. Does anyone
> know how I can get my subscriptions working to real email addresses and not
> just local accounts? Any help would be appreciated.
> Thanks,
> Jeff|||How exactly did you do that? I have looked around for hours, you're the only
that has my exact same problem.
"Jeff McIntire" wrote:
> I have solved my own issue. All I needed to do was edit the SMTP server
> settings to grant access to the server to relay through its own IP address.
> Jeff
> "Jeff McIntire" wrote:
> > Hello all,
> >
> > I am trying to get some email subscriptions setup and I keep getting the
> > message "The e-mail address of one or more recipients is not valid". The
> > email address is valid and I am not sure what the problem is. If I set the
> > email address to a local account name (i.e Administrator) the subscription
> > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > know how I can get my subscriptions working to real email addresses and not
> > just local accounts? Any help would be appreciated.
> >
> > Thanks,
> >
> > Jeff|||All I did was go to the SMTP server properties and click on the access tab.
Then I clicked the relay button at the bottom of the page. Next I clicked on
add and inputted the IP address of my server. Then I clicked ok and made
sure the radio button labeled â'Only the list belowâ' was selected. That
solved my problem and I hope it solves yours as well.
Thanks,
Jeff
"DougM" wrote:
> How exactly did you do that? I have looked around for hours, you're the only
> that has my exact same problem.
> "Jeff McIntire" wrote:
> > I have solved my own issue. All I needed to do was edit the SMTP server
> > settings to grant access to the server to relay through its own IP address.
> >
> > Jeff
> >
> > "Jeff McIntire" wrote:
> >
> > > Hello all,
> > >
> > > I am trying to get some email subscriptions setup and I keep getting the
> > > message "The e-mail address of one or more recipients is not valid". The
> > > email address is valid and I am not sure what the problem is. If I set the
> > > email address to a local account name (i.e Administrator) the subscription
> > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > know how I can get my subscriptions working to real email addresses and not
> > > just local accounts? Any help would be appreciated.
> > >
> > > Thanks,
> > >
> > > Jeff|||Thanks, I tried re-installing Reporting Services to see if I could see that
screen but after choosing to modify components (as opposed to uninstall) it
went right through to finish...How did you get to the SMTP properties?. I
appreciate your help very much.
Regards,
DougM
"Jeff McIntire" wrote:
> All I did was go to the SMTP server properties and click on the access tab.
> Then I clicked the relay button at the bottom of the page. Next I clicked on
> add and inputted the IP address of my server. Then I clicked ok and made
> sure the radio button labeled â'Only the list belowâ' was selected. That
> solved my problem and I hope it solves yours as well.
> Thanks,
> Jeff
>
> "DougM" wrote:
> > How exactly did you do that? I have looked around for hours, you're the only
> > that has my exact same problem.
> >
> > "Jeff McIntire" wrote:
> >
> > > I have solved my own issue. All I needed to do was edit the SMTP server
> > > settings to grant access to the server to relay through its own IP address.
> > >
> > > Jeff
> > >
> > > "Jeff McIntire" wrote:
> > >
> > > > Hello all,
> > > >
> > > > I am trying to get some email subscriptions setup and I keep getting the
> > > > message "The e-mail address of one or more recipients is not valid". The
> > > > email address is valid and I am not sure what the problem is. If I set the
> > > > email address to a local account name (i.e Administrator) the subscription
> > > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > > know how I can get my subscriptions working to real email addresses and not
> > > > just local accounts? Any help would be appreciated.
> > > >
> > > > Thanks,
> > > >
> > > > Jeff|||I am sorry. Perhaps I should have clarified. The SMTP properties that I was
referring to were in the SMTP server in IIS itself. If you open up IIS and
navigate to the SMTP server and then right click on it and go to properties
you should find the screens that I was referring to.
Thanks,
Jeff
"DougM" wrote:
> Thanks, I tried re-installing Reporting Services to see if I could see that
> screen but after choosing to modify components (as opposed to uninstall) it
> went right through to finish...How did you get to the SMTP properties?. I
> appreciate your help very much.
> Regards,
> DougM
> "Jeff McIntire" wrote:
> > All I did was go to the SMTP server properties and click on the access tab.
> > Then I clicked the relay button at the bottom of the page. Next I clicked on
> > add and inputted the IP address of my server. Then I clicked ok and made
> > sure the radio button labeled â'Only the list belowâ' was selected. That
> > solved my problem and I hope it solves yours as well.
> >
> > Thanks,
> >
> > Jeff
> >
> >
> > "DougM" wrote:
> >
> > > How exactly did you do that? I have looked around for hours, you're the only
> > > that has my exact same problem.
> > >
> > > "Jeff McIntire" wrote:
> > >
> > > > I have solved my own issue. All I needed to do was edit the SMTP server
> > > > settings to grant access to the server to relay through its own IP address.
> > > >
> > > > Jeff
> > > >
> > > > "Jeff McIntire" wrote:
> > > >
> > > > > Hello all,
> > > > >
> > > > > I am trying to get some email subscriptions setup and I keep getting the
> > > > > message "The e-mail address of one or more recipients is not valid". The
> > > > > email address is valid and I am not sure what the problem is. If I set the
> > > > > email address to a local account name (i.e Administrator) the subscription
> > > > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > > > know how I can get my subscriptions working to real email addresses and not
> > > > > just local accounts? Any help would be appreciated.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Jeff
I am trying to get some email subscriptions setup and I keep getting the
message "The e-mail address of one or more recipients is not valid". The
email address is valid and I am not sure what the problem is. If I set the
email address to a local account name (i.e Administrator) the subscription
works and e-mail shows up in the drop folder of the smtp server. Does anyone
know how I can get my subscriptions working to real email addresses and not
just local accounts? Any help would be appreciated.
Thanks,
JeffI have solved my own issue. All I needed to do was edit the SMTP server
settings to grant access to the server to relay through its own IP address.
Jeff
"Jeff McIntire" wrote:
> Hello all,
> I am trying to get some email subscriptions setup and I keep getting the
> message "The e-mail address of one or more recipients is not valid". The
> email address is valid and I am not sure what the problem is. If I set the
> email address to a local account name (i.e Administrator) the subscription
> works and e-mail shows up in the drop folder of the smtp server. Does anyone
> know how I can get my subscriptions working to real email addresses and not
> just local accounts? Any help would be appreciated.
> Thanks,
> Jeff|||How exactly did you do that? I have looked around for hours, you're the only
that has my exact same problem.
"Jeff McIntire" wrote:
> I have solved my own issue. All I needed to do was edit the SMTP server
> settings to grant access to the server to relay through its own IP address.
> Jeff
> "Jeff McIntire" wrote:
> > Hello all,
> >
> > I am trying to get some email subscriptions setup and I keep getting the
> > message "The e-mail address of one or more recipients is not valid". The
> > email address is valid and I am not sure what the problem is. If I set the
> > email address to a local account name (i.e Administrator) the subscription
> > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > know how I can get my subscriptions working to real email addresses and not
> > just local accounts? Any help would be appreciated.
> >
> > Thanks,
> >
> > Jeff|||All I did was go to the SMTP server properties and click on the access tab.
Then I clicked the relay button at the bottom of the page. Next I clicked on
add and inputted the IP address of my server. Then I clicked ok and made
sure the radio button labeled â'Only the list belowâ' was selected. That
solved my problem and I hope it solves yours as well.
Thanks,
Jeff
"DougM" wrote:
> How exactly did you do that? I have looked around for hours, you're the only
> that has my exact same problem.
> "Jeff McIntire" wrote:
> > I have solved my own issue. All I needed to do was edit the SMTP server
> > settings to grant access to the server to relay through its own IP address.
> >
> > Jeff
> >
> > "Jeff McIntire" wrote:
> >
> > > Hello all,
> > >
> > > I am trying to get some email subscriptions setup and I keep getting the
> > > message "The e-mail address of one or more recipients is not valid". The
> > > email address is valid and I am not sure what the problem is. If I set the
> > > email address to a local account name (i.e Administrator) the subscription
> > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > know how I can get my subscriptions working to real email addresses and not
> > > just local accounts? Any help would be appreciated.
> > >
> > > Thanks,
> > >
> > > Jeff|||Thanks, I tried re-installing Reporting Services to see if I could see that
screen but after choosing to modify components (as opposed to uninstall) it
went right through to finish...How did you get to the SMTP properties?. I
appreciate your help very much.
Regards,
DougM
"Jeff McIntire" wrote:
> All I did was go to the SMTP server properties and click on the access tab.
> Then I clicked the relay button at the bottom of the page. Next I clicked on
> add and inputted the IP address of my server. Then I clicked ok and made
> sure the radio button labeled â'Only the list belowâ' was selected. That
> solved my problem and I hope it solves yours as well.
> Thanks,
> Jeff
>
> "DougM" wrote:
> > How exactly did you do that? I have looked around for hours, you're the only
> > that has my exact same problem.
> >
> > "Jeff McIntire" wrote:
> >
> > > I have solved my own issue. All I needed to do was edit the SMTP server
> > > settings to grant access to the server to relay through its own IP address.
> > >
> > > Jeff
> > >
> > > "Jeff McIntire" wrote:
> > >
> > > > Hello all,
> > > >
> > > > I am trying to get some email subscriptions setup and I keep getting the
> > > > message "The e-mail address of one or more recipients is not valid". The
> > > > email address is valid and I am not sure what the problem is. If I set the
> > > > email address to a local account name (i.e Administrator) the subscription
> > > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > > know how I can get my subscriptions working to real email addresses and not
> > > > just local accounts? Any help would be appreciated.
> > > >
> > > > Thanks,
> > > >
> > > > Jeff|||I am sorry. Perhaps I should have clarified. The SMTP properties that I was
referring to were in the SMTP server in IIS itself. If you open up IIS and
navigate to the SMTP server and then right click on it and go to properties
you should find the screens that I was referring to.
Thanks,
Jeff
"DougM" wrote:
> Thanks, I tried re-installing Reporting Services to see if I could see that
> screen but after choosing to modify components (as opposed to uninstall) it
> went right through to finish...How did you get to the SMTP properties?. I
> appreciate your help very much.
> Regards,
> DougM
> "Jeff McIntire" wrote:
> > All I did was go to the SMTP server properties and click on the access tab.
> > Then I clicked the relay button at the bottom of the page. Next I clicked on
> > add and inputted the IP address of my server. Then I clicked ok and made
> > sure the radio button labeled â'Only the list belowâ' was selected. That
> > solved my problem and I hope it solves yours as well.
> >
> > Thanks,
> >
> > Jeff
> >
> >
> > "DougM" wrote:
> >
> > > How exactly did you do that? I have looked around for hours, you're the only
> > > that has my exact same problem.
> > >
> > > "Jeff McIntire" wrote:
> > >
> > > > I have solved my own issue. All I needed to do was edit the SMTP server
> > > > settings to grant access to the server to relay through its own IP address.
> > > >
> > > > Jeff
> > > >
> > > > "Jeff McIntire" wrote:
> > > >
> > > > > Hello all,
> > > > >
> > > > > I am trying to get some email subscriptions setup and I keep getting the
> > > > > message "The e-mail address of one or more recipients is not valid". The
> > > > > email address is valid and I am not sure what the problem is. If I set the
> > > > > email address to a local account name (i.e Administrator) the subscription
> > > > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > > > know how I can get my subscriptions working to real email addresses and not
> > > > > just local accounts? Any help would be appreciated.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Jeff
e-mail subscription quit working - can't figure out why
Hi All,
I am using SQL Reporting Services MOM Reporting. I set up some reports and
they have been delivering flawlessley now for over a month. Now this morning
I got the error:
"Failure sending mail: The transport failed to connect to the server. "
It isn't descriptive enough to know what exactly failed. I can ping and
telnet to the SMTP port of the mail server and not being blocked. Also, the
same settings are being used for alerts from MOM without any problems. Is
there a way to run a test or get a better log to know what the error is?
This error is useless.
Thanks,
--GREG--I had experienced similar behavior. We resolved this by changing the
SMTP server specified in the Email Settings within Report Services
Configuration tool from the server name to the mail server's IP
address. Hope this helps!
Midas
I am using SQL Reporting Services MOM Reporting. I set up some reports and
they have been delivering flawlessley now for over a month. Now this morning
I got the error:
"Failure sending mail: The transport failed to connect to the server. "
It isn't descriptive enough to know what exactly failed. I can ping and
telnet to the SMTP port of the mail server and not being blocked. Also, the
same settings are being used for alerts from MOM without any problems. Is
there a way to run a test or get a better log to know what the error is?
This error is useless.
Thanks,
--GREG--I had experienced similar behavior. We resolved this by changing the
SMTP server specified in the Email Settings within Report Services
Configuration tool from the server name to the mail server's IP
address. Hope this helps!
Midas
E-mail subscription not a option
Hi,
I'am running reporting services 2000 and I'am having a problem with e-mail
subscriptions. Here the low down.
My reports run without any problems but when I click on new subscription the
only option available is Report server file share. There's no option for
E-mail. At one point I was able to select the e-mail option but decided to
re-do my 2003 server. Any help with this issue would be more than welcomed.Hi,
Fairly simple. Go to ReportServer directory and open RSreportserver.config
search for <Delivery> and inside that find for "Report Server Email" and add
the required things like from:, SMTP server, account name etc...
and restart the reporting server once; you should be getting this option as
well.
Amarnath
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Amarnath,
I've tried that serveral times already and still the e-mail option is not
available. I'am on a corporate domain. Keep in mind that the option was there
a one time, but after I re-did the server I noticed this problem. This is the
delivery section from my RSreportserver.config:
<Delivery>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtprelay.montefiore.org</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
"Amarnath" wrote:
> Hi,
> Fairly simple. Go to ReportServer directory and open RSreportserver.config
> search for <Delivery> and inside that find for "Report Server Email" and add
> the required things like from:, SMTP server, account name etc...
> and restart the reporting server once; you should be getting this option as
> well.
> Amarnath
> "Robert Douglas" wrote:
> > Hi,
> >
> > I'am running reporting services 2000 and I'am having a problem with e-mail
> > subscriptions. Here the low down.
> >
> > My reports run without any problems but when I click on new subscription the
> > only option available is Report server file share. There's no option for
> > E-mail. At one point I was able to select the e-mail option but decided to
> > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Hi Robert,
Try giving IP address in <SMTPServer> section. I faced the same problem.
Amarnath
"Robert Douglas" wrote:
> Amarnath,
> I've tried that serveral times already and still the e-mail option is not
> available. I'am on a corporate domain. Keep in mind that the option was there
> a one time, but after I re-did the server I noticed this problem. This is the
> delivery section from my RSreportserver.config:
> <Delivery>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From></From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
>
> "Amarnath" wrote:
> > Hi,
> > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > search for <Delivery> and inside that find for "Report Server Email" and add
> > the required things like from:, SMTP server, account name etc...
> > and restart the reporting server once; you should be getting this option as
> > well.
> > Amarnath
> >
> > "Robert Douglas" wrote:
> >
> > > Hi,
> > >
> > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > subscriptions. Here the low down.
> > >
> > > My reports run without any problems but when I click on new subscription the
> > > only option available is Report server file share. There's no option for
> > > E-mail. At one point I was able to select the e-mail option but decided to
> > > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Same problem
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Well I managed to get the e-mail option back but e-mail still not working.
I'll keep on trying.
"Amarnath" wrote:
> Hi Robert,
> Try giving IP address in <SMTPServer> section. I faced the same problem.
> Amarnath
> "Robert Douglas" wrote:
> > Amarnath,
> >
> > I've tried that serveral times already and still the e-mail option is not
> > available. I'am on a corporate domain. Keep in mind that the option was there
> > a one time, but after I re-did the server I noticed this problem. This is the
> > delivery section from my RSreportserver.config:
> >
> > <Delivery>
> > <Extension Name="Report Server Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> > <SMTPServerPort></SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate></SMTPAuthenticate>
> > <From></From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > <DefaultHostName></DefaultHostName>
> > <PermittedHosts></PermittedHosts>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="NULL"
> > Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> > </Delivery>
> >
> >
> > "Amarnath" wrote:
> >
> > > Hi,
> > > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > > search for <Delivery> and inside that find for "Report Server Email" and add
> > > the required things like from:, SMTP server, account name etc...
> > > and restart the reporting server once; you should be getting this option as
> > > well.
> > > Amarnath
> > >
> > > "Robert Douglas" wrote:
> > >
> > > > Hi,
> > > >
> > > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > > subscriptions. Here the low down.
> > > >
> > > > My reports run without any problems but when I click on new subscription the
> > > > only option available is Report server file share. There's no option for
> > > > E-mail. At one point I was able to select the e-mail option but decided to
> > > > re-do my 2003 server. Any help with this issue would be more than welcomed.
I'am running reporting services 2000 and I'am having a problem with e-mail
subscriptions. Here the low down.
My reports run without any problems but when I click on new subscription the
only option available is Report server file share. There's no option for
E-mail. At one point I was able to select the e-mail option but decided to
re-do my 2003 server. Any help with this issue would be more than welcomed.Hi,
Fairly simple. Go to ReportServer directory and open RSreportserver.config
search for <Delivery> and inside that find for "Report Server Email" and add
the required things like from:, SMTP server, account name etc...
and restart the reporting server once; you should be getting this option as
well.
Amarnath
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Amarnath,
I've tried that serveral times already and still the e-mail option is not
available. I'am on a corporate domain. Keep in mind that the option was there
a one time, but after I re-did the server I noticed this problem. This is the
delivery section from my RSreportserver.config:
<Delivery>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtprelay.montefiore.org</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
"Amarnath" wrote:
> Hi,
> Fairly simple. Go to ReportServer directory and open RSreportserver.config
> search for <Delivery> and inside that find for "Report Server Email" and add
> the required things like from:, SMTP server, account name etc...
> and restart the reporting server once; you should be getting this option as
> well.
> Amarnath
> "Robert Douglas" wrote:
> > Hi,
> >
> > I'am running reporting services 2000 and I'am having a problem with e-mail
> > subscriptions. Here the low down.
> >
> > My reports run without any problems but when I click on new subscription the
> > only option available is Report server file share. There's no option for
> > E-mail. At one point I was able to select the e-mail option but decided to
> > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Hi Robert,
Try giving IP address in <SMTPServer> section. I faced the same problem.
Amarnath
"Robert Douglas" wrote:
> Amarnath,
> I've tried that serveral times already and still the e-mail option is not
> available. I'am on a corporate domain. Keep in mind that the option was there
> a one time, but after I re-did the server I noticed this problem. This is the
> delivery section from my RSreportserver.config:
> <Delivery>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From></From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
>
> "Amarnath" wrote:
> > Hi,
> > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > search for <Delivery> and inside that find for "Report Server Email" and add
> > the required things like from:, SMTP server, account name etc...
> > and restart the reporting server once; you should be getting this option as
> > well.
> > Amarnath
> >
> > "Robert Douglas" wrote:
> >
> > > Hi,
> > >
> > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > subscriptions. Here the low down.
> > >
> > > My reports run without any problems but when I click on new subscription the
> > > only option available is Report server file share. There's no option for
> > > E-mail. At one point I was able to select the e-mail option but decided to
> > > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Same problem
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Well I managed to get the e-mail option back but e-mail still not working.
I'll keep on trying.
"Amarnath" wrote:
> Hi Robert,
> Try giving IP address in <SMTPServer> section. I faced the same problem.
> Amarnath
> "Robert Douglas" wrote:
> > Amarnath,
> >
> > I've tried that serveral times already and still the e-mail option is not
> > available. I'am on a corporate domain. Keep in mind that the option was there
> > a one time, but after I re-did the server I noticed this problem. This is the
> > delivery section from my RSreportserver.config:
> >
> > <Delivery>
> > <Extension Name="Report Server Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> > <SMTPServerPort></SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate></SMTPAuthenticate>
> > <From></From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > <DefaultHostName></DefaultHostName>
> > <PermittedHosts></PermittedHosts>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="NULL"
> > Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> > </Delivery>
> >
> >
> > "Amarnath" wrote:
> >
> > > Hi,
> > > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > > search for <Delivery> and inside that find for "Report Server Email" and add
> > > the required things like from:, SMTP server, account name etc...
> > > and restart the reporting server once; you should be getting this option as
> > > well.
> > > Amarnath
> > >
> > > "Robert Douglas" wrote:
> > >
> > > > Hi,
> > > >
> > > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > > subscriptions. Here the low down.
> > > >
> > > > My reports run without any problems but when I click on new subscription the
> > > > only option available is Report server file share. There's no option for
> > > > E-mail. At one point I was able to select the e-mail option but decided to
> > > > re-do my 2003 server. Any help with this issue would be more than welcomed.
Wednesday, March 21, 2012
EMail Subscription Error
All of a sudden, the e-mail subscriptions for a report quit being sent.
Running Sql 2000
Microsoft SQL Server Reporting Services Version 8.00.743.00
Here is the log error:
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!e08!12/11/2006-08:39:10:: i INFO: Call to GetPermissions:/Maximo/PO with Received Date Details
aspnet_wp!chunks!e08!12/11/2006-08:39:10:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!e08!12/11/2006-08:39:10:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
Any suggestions? Anyone see this before?
Are you sure that you wanted to attach this logfile extract? You mention subscription problem as an original one. But the logfile extract is taken from UI (Reportmanager) logfile, not from the server logfile: reported by aspnet_wp component and stack starts from System.Web.Hosting.ISAPIRuntime.ProcessRequest. If your problem is related to the subscription that suddenly discontinued to work, please attach the corresponding piece from the reportserver_<date>.logh file.
|||Ah, thanks for that help. Here is that log:
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!chunks!c80!12/12/2006-10:48:06:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.ProcessReportParametersCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.Library.RSService.GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedParametersCollection(NameValueCollection userSpecifiedParams)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.RenderViewer(String reportName, ReportUrl location, NameValueCollection reportParameters, DatasourceCredentialsCollection dataSourceCredentials, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, CreateAndRegisterStream createAndRegisterStream)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.PreRender(RSService service, CatalogItemContext itemContext, CreateAndRegisterStream createAndRegisterStream, Boolean isSnapshot)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:30:: i INFO: Call to RenderFirst( '/Maximo/PO Details' )
aspnet_wp!chunks!c80!12/12/2006-10:48:30:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:30:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:31:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!c80!12/12/2006-10:48:31:: i INFO: Processed report. Report='/Maximo/PO Details', Stream=''
aspnet_wp!library!d4c!12/12/2006-10:49:06:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
aspnet_wp!session!c80!12/12/2006-10:49:38:: i INFO: LoadSnapshot: Item with session: cbm0l1yg4tjjvs55u2wxlp55, reportPath: /Maximo/PO By Material Received Date, userName: BNFLIDAHO\rosesi not found in the database
aspnet_wp!library!c80!12/12/2006-10:49:38:: i INFO: Call to RenderFirst( '/Maximo/PO By Material Received Date' )
aspnet_wp!library!c80!12/12/2006-10:49:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
James,
All attached errors are logged by the web service when you run report via the Report Manager. You can see that by the name of the process that is the first token in the every log entry: aspnet_wp; and by the initial call in the call stack: System.Web.Hosting.ISAPIRuntime.ProcessRequest. Attached errors may be valuable if they are related to the problem you have. They indicate that there is a problem with the retrieving data sources for a sub-report when you try to execute a report via the ReportManager.
For the subscription problem you reported originally you need to take a look on the logfile written by RS windows service. Something like ReportServerService__12_12_2006_13_05_41.log. Sorry , in my previous post I put a wrong name for it. Try to locate the logfile coresponding to the subscription using the timestamp in the logfile name, and then find the errors in the logfile corresponding to the subscription using timestamps within the file.
-Igor
e-mail setup on SQL 2000 std
Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
Zoran
YOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
Zoran
YOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
e-mail setup on SQL 2000 std
Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Süßmeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||Yes! :o)
Aaron, thanx!
I checked the link you sent me, and I understood that I should be logging on
with SQL service account.
Once I did that, I could configure the whole thing!
Thanx again!
Regards, Zoran
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
news:%23MjmN8CQFHA.2680@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2403
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Kizetoni" <kizetoni@.mail.ru> wrote in message
> news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> > Hello All,
> >
> > I am trying to set up e-mail notification, but when I open SQL Server
> > Agent
> > (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> > Profile.
> >
> > I have Outlook 2002 (XP) installed on the machine, and I tried
configuring
> > a
> > profile with POP and IMAP account, but no mather what I do, the Mail
> > Profile
> > is stil outgreyed. I don't have MAPI access from that machine, but
> > according
> > to some books I refered to it shouldn't be a must.
> >
> > As I can see, either it should be a MAPI, or I am missing something that
> > should be installed on SQL server, a component or something like that.
> >
> > Any ideas?
> >
> > Thanx in advance,
> > Zoran
> >
> >
>sql
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Süßmeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||Yes! :o)
Aaron, thanx!
I checked the link you sent me, and I understood that I should be logging on
with SQL service account.
Once I did that, I could configure the whole thing!
Thanx again!
Regards, Zoran
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
news:%23MjmN8CQFHA.2680@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2403
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Kizetoni" <kizetoni@.mail.ru> wrote in message
> news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> > Hello All,
> >
> > I am trying to set up e-mail notification, but when I open SQL Server
> > Agent
> > (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> > Profile.
> >
> > I have Outlook 2002 (XP) installed on the machine, and I tried
configuring
> > a
> > profile with POP and IMAP account, but no mather what I do, the Mail
> > Profile
> > is stil outgreyed. I don't have MAPI access from that machine, but
> > according
> > to some books I refered to it shouldn't be a must.
> >
> > As I can see, either it should be a MAPI, or I am missing something that
> > should be installed on SQL server, a component or something like that.
> >
> > Any ideas?
> >
> > Thanx in advance,
> > Zoran
> >
> >
>sql
e-mail setup on SQL 2000 std
Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Smeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>
Email results from trigger tables
I'm trying to e-mail the results of a trigger that fires on an employee
table. I'm trying to included the results of either the DELETED or INSERTED
tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
table queries in the @.query = parameter?
I'm trying to send an e-mail to someone whenever a new employee is added or
deleted.
Thanks.
Regardless that doesn′t work because the new session with XP_sendmail won′t
know about your deleted tables, the action you want to perform is not
preferable, because mail sending will be done synchronisly. So if your
mailserver is stuck in a problem and need 5 minutes for sending a mail (for
some reason) your transaction will hold on for that time, if the process
throws an error, your transaction might rollback. You don′t want that, erh ?
I would suggest (as this is not time critical) to write the data in a table
which is regulary checked for content to be sent.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Shawn Barrow" wrote:
> I'm trying to e-mail the results of a trigger that fires on an employee
> table. I'm trying to included the results of either the DELETED or INSERTED
> tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
> table queries in the @.query = parameter?
> I'm trying to send an e-mail to someone whenever a new employee is added or
> deleted.
> Thanks.
table. I'm trying to included the results of either the DELETED or INSERTED
tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
table queries in the @.query = parameter?
I'm trying to send an e-mail to someone whenever a new employee is added or
deleted.
Thanks.
Regardless that doesn′t work because the new session with XP_sendmail won′t
know about your deleted tables, the action you want to perform is not
preferable, because mail sending will be done synchronisly. So if your
mailserver is stuck in a problem and need 5 minutes for sending a mail (for
some reason) your transaction will hold on for that time, if the process
throws an error, your transaction might rollback. You don′t want that, erh ?
I would suggest (as this is not time critical) to write the data in a table
which is regulary checked for content to be sent.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Shawn Barrow" wrote:
> I'm trying to e-mail the results of a trigger that fires on an employee
> table. I'm trying to included the results of either the DELETED or INSERTED
> tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
> table queries in the @.query = parameter?
> I'm trying to send an e-mail to someone whenever a new employee is added or
> deleted.
> Thanks.
Email results from trigger tables
I'm trying to e-mail the results of a trigger that fires on an employee
table. I'm trying to included the results of either the DELETED or INSERTED
tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
table queries in the @.query = parameter?
I'm trying to send an e-mail to someone whenever a new employee is added or
deleted.
Thanks.Regardless that doesn´t work because the new session with XP_sendmail won´t
know about your deleted tables, the action you want to perform is not
preferable, because mail sending will be done synchronisly. So if your
mailserver is stuck in a problem and need 5 minutes for sending a mail (for
some reason) your transaction will hold on for that time, if the process
throws an error, your transaction might rollback. You don´t want that, erh ?
I would suggest (as this is not time critical) to write the data in a table
which is regulary checked for content to be sent.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Shawn Barrow" wrote:
> I'm trying to e-mail the results of a trigger that fires on an employee
> table. I'm trying to included the results of either the DELETED or INSERTED
> tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
> table queries in the @.query = parameter?
> I'm trying to send an e-mail to someone whenever a new employee is added or
> deleted.
> Thanks.
table. I'm trying to included the results of either the DELETED or INSERTED
tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
table queries in the @.query = parameter?
I'm trying to send an e-mail to someone whenever a new employee is added or
deleted.
Thanks.Regardless that doesn´t work because the new session with XP_sendmail won´t
know about your deleted tables, the action you want to perform is not
preferable, because mail sending will be done synchronisly. So if your
mailserver is stuck in a problem and need 5 minutes for sending a mail (for
some reason) your transaction will hold on for that time, if the process
throws an error, your transaction might rollback. You don´t want that, erh ?
I would suggest (as this is not time critical) to write the data in a table
which is regulary checked for content to be sent.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Shawn Barrow" wrote:
> I'm trying to e-mail the results of a trigger that fires on an employee
> table. I'm trying to included the results of either the DELETED or INSERTED
> tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED
> table queries in the @.query = parameter?
> I'm trying to send an e-mail to someone whenever a new employee is added or
> deleted.
> Thanks.
Email results from trigger tables
I'm trying to e-mail the results of a trigger that fires on an employee
table. I'm trying to included the results of either the DELETED or INSERTED
tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTE
D
table queries in the @.query = parameter?
I'm trying to send an e-mail to someone whenever a new employee is added or
deleted.
Thanks.Regardless that doesn′t work because the new session with XP_sendmail won′
t
know about your deleted tables, the action you want to perform is not
preferable, because mail sending will be done synchronisly. So if your
mailserver is stuck in a problem and need 5 minutes for sending a mail (for
some reason) your transaction will hold on for that time, if the process
throws an error, your transaction might rollback. You don′t want that, erh
?
I would suggest (as this is not time critical) to write the data in a table
which is regulary checked for content to be sent.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Shawn Barrow" wrote:
> I'm trying to e-mail the results of a trigger that fires on an employee
> table. I'm trying to included the results of either the DELETED or INSERT
ED
> tables, but nothing is returned. Can xp_sendmail include DELETED or INSER
TED
> table queries in the @.query = parameter?
> I'm trying to send an e-mail to someone whenever a new employee is added o
r
> deleted.
> Thanks.
table. I'm trying to included the results of either the DELETED or INSERTED
tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTE
D
table queries in the @.query = parameter?
I'm trying to send an e-mail to someone whenever a new employee is added or
deleted.
Thanks.Regardless that doesn′t work because the new session with XP_sendmail won′
t
know about your deleted tables, the action you want to perform is not
preferable, because mail sending will be done synchronisly. So if your
mailserver is stuck in a problem and need 5 minutes for sending a mail (for
some reason) your transaction will hold on for that time, if the process
throws an error, your transaction might rollback. You don′t want that, erh
?
I would suggest (as this is not time critical) to write the data in a table
which is regulary checked for content to be sent.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Shawn Barrow" wrote:
> I'm trying to e-mail the results of a trigger that fires on an employee
> table. I'm trying to included the results of either the DELETED or INSERT
ED
> tables, but nothing is returned. Can xp_sendmail include DELETED or INSER
TED
> table queries in the @.query = parameter?
> I'm trying to send an e-mail to someone whenever a new employee is added o
r
> deleted.
> Thanks.
Email passwords
I am desigining an intranet site using vb.net/asp.net. The sql - users table has a username, password, e-mail address and date field (date is for when the user last updated there password). My login page etc is working fine, but what I want to do is when someone types in the wrong password, to send an email to the address from my users table giving them the correct password. I am not sure how to go about doing this and would appreciate any advice on this.I am desigining an intranet site using vb.net/asp.net. The sql - users table has a username, password, e-mail address and date field (date is for when the user last updated there password). My login page etc is working fine, but what I want to do is when someone types in the wrong password, to send an email to the address from my users table giving them the correct password. I am not sure how to go about doing this and would appreciate any advice on this.
Won't that be a bit dangerous and a security risk?
To E-mail the password when the user typed it wrong?
What if His/Her significant other or a friend or a neighbor takes a peek at the e-mail?
:mad:sql
Won't that be a bit dangerous and a security risk?
To E-mail the password when the user typed it wrong?
What if His/Her significant other or a friend or a neighbor takes a peek at the e-mail?
:mad:sql
Monday, March 19, 2012
email notifications scheduled jobs
In the notifications tab of the job I have e-mail operator selected. Click on the box with the elipses to enter the email addresses. It will let me enter 2 email addresses in the e-mail name field. It looks like the field has a limited length...is there a way to manually enter several addresses?http://www.sqlmag.com/Article/ArticleID/21450/sql_server_21450.html
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=31
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=31
E-mail notifications
Hi,
.I have 4 tables:
Users
--
userid(PK) username pass addr
Offer
--
offerid(PK) userid(FK to Users) estateid(FK to Estates) price
rooms
Estate
--
estateid(PK) city phone addr date ...
Search
--
searchid(PK) userid(FK to Users) estateid(FKto Estates) min price
max price min rooms maxrooms
In the Search table I store information about every user which wants to
receive automatically information about Estates. I don't know how to
accomplish that. With trigger or something else. In Search could be stored
info from 300-400 users which wants to receive e-mail notifications about
estates by their
criteria everytime when a estate is inserted and it is what they want. .
Could someone gives me a solution for that problem?
Thank you!
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.Check Notification Services for SQL Server, that would help i think.
"Viktor Popov" wrote:
> Hi,
> ..I have 4 tables:
> Users
> --
> userid(PK) username pass addr
> Offer
> --
> offerid(PK) userid(FK to Users) estateid(FK to Estates) price
> rooms
> Estate
> --
> estateid(PK) city phone addr date ...
> Search
> --
> searchid(PK) userid(FK to Users) estateid(FKto Estates) min price
> max price min rooms maxrooms
>
> In the Search table I store information about every user which wants to
> receive automatically information about Estates. I don't know how to
> accomplish that. With trigger or something else. In Search could be stored
> info from 300-400 users which wants to receive e-mail notifications about
> estates by their
> criteria everytime when a estate is inserted and it is what they want. .
> Could someone gives me a solution for that problem?
> Thank you!
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
>
>
.I have 4 tables:
Users
--
userid(PK) username pass addr
Offer
--
offerid(PK) userid(FK to Users) estateid(FK to Estates) price
rooms
Estate
--
estateid(PK) city phone addr date ...
Search
--
searchid(PK) userid(FK to Users) estateid(FKto Estates) min price
max price min rooms maxrooms
In the Search table I store information about every user which wants to
receive automatically information about Estates. I don't know how to
accomplish that. With trigger or something else. In Search could be stored
info from 300-400 users which wants to receive e-mail notifications about
estates by their
criteria everytime when a estate is inserted and it is what they want. .
Could someone gives me a solution for that problem?
Thank you!
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.Check Notification Services for SQL Server, that would help i think.
"Viktor Popov" wrote:
> Hi,
> ..I have 4 tables:
> Users
> --
> userid(PK) username pass addr
> Offer
> --
> offerid(PK) userid(FK to Users) estateid(FK to Estates) price
> rooms
> Estate
> --
> estateid(PK) city phone addr date ...
> Search
> --
> searchid(PK) userid(FK to Users) estateid(FKto Estates) min price
> max price min rooms maxrooms
>
> In the Search table I store information about every user which wants to
> receive automatically information about Estates. I don't know how to
> accomplish that. With trigger or something else. In Search could be stored
> info from 300-400 users which wants to receive e-mail notifications about
> estates by their
> criteria everytime when a estate is inserted and it is what they want. .
> Could someone gives me a solution for that problem?
> Thank you!
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
>
>
Subscribe to:
Posts (Atom)