How can I remove "include report" option from the email subscripti

I don't want users to have the "include report" option when setting up an
email subscription. Is it possible? I want users to only be able to get a
link to the report to avoid attachments in the inbox.
I was expecting to be able to set it in RSReportServer.config file, but I
didn't find an option.The email delivery extension does not support this scenario. You could look
into writing your own delivery extension. Since all you want to do is email
a link it would be fairly simple to write, the hardest part would be the UI.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JulioLe" <JulioLe@.discussions.microsoft.com> wrote in message
news:7E95C301-6D46-47E6-8E6C-CEDEC9A57CEA@.microsoft.com...
>I don't want users to have the "include report" option when setting up an
> email subscription. Is it possible? I want users to only be able to get a
> link to the report to avoid attachments in the inbox.
> I was expecting to be able to set it in RSReportServer.config file, but I
> didn't find an option.
>

How can I know the "SQL Server" Service is down ?

Dear,
How can I make a SQL Server able to send me an email alert if its SQL Server
Service and/or SQL Server Agent Service is down automatically ?
SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they can
monitor themselves.
Are there any other way to monitor them ? Either from Microsoft Windows
system or third party softwares.The simplest solution is to configure MOM (assuming you have deployed it).
Otherwise you need to do this in Windows. In the Computer Management -
Services node, display the properties pages of the services of interest and
configure the recovery page.
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ff47de$1@.127.0.0.1...
> Dear,
> How can I make a SQL Server able to send me an email alert if its SQL
> Server
> Service and/or SQL Server Agent Service is down automatically ?
> SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
> can
> monitor themselves.
> Are there any other way to monitor them ? Either from Microsoft Windows
> system or third party softwares.
>|||Dear Yudkin,
What does MOM stand for ?
Please tell me, thanks a lot.
"Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
> The simplest solution is to configure MOM (assuming you have deployed it).
> Otherwise you need to do this in Windows. In the Computer Management -
> Services node, display the properties pages of the services of interest
and
> configure the recovery page.
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:46ff47de$1@.127.0.0.1...
> > Dear,
> >
> > How can I make a SQL Server able to send me an email alert if its SQL
> > Server
> > Service and/or SQL Server Agent Service is down automatically ?
> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
> > can
> > monitor themselves.
> >
> > Are there any other way to monitor them ? Either from Microsoft Windows
> > system or third party softwares.
> >
> >
>|||> What does MOM stand for ?
Microsoft Operations Manager. See
http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ffa2bc$1@.127.0.0.1...
> Dear Yudkin,
> What does MOM stand for ?
> Please tell me, thanks a lot.
> "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
> news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
>> The simplest solution is to configure MOM (assuming you have deployed
>> it).
>> Otherwise you need to do this in Windows. In the Computer Management -
>> Services node, display the properties pages of the services of interest
> and
>> configure the recovery page.
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:46ff47de$1@.127.0.0.1...
>> > Dear,
>> >
>> > How can I make a SQL Server able to send me an email alert if its SQL
>> > Server
>> > Service and/or SQL Server Agent Service is down automatically ?
>> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
>> > can
>> > monitor themselves.
>> >
>> > Are there any other way to monitor them ? Either from Microsoft Windows
>> > system or third party softwares.
>> >
>> >
>>
>|||Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Od9MKe2AIHA.288@.TK2MSFTNGP02.phx.gbl...
> > What does MOM stand for ?
> Microsoft Operations Manager. See
> http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:46ffa2bc$1@.127.0.0.1...
> > Dear Yudkin,
> >
> > What does MOM stand for ?
> > Please tell me, thanks a lot.
> >
> > "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
> > news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
> >> The simplest solution is to configure MOM (assuming you have deployed
> >> it).
> >>
> >> Otherwise you need to do this in Windows. In the Computer Management -
> >> Services node, display the properties pages of the services of interest
> > and
> >> configure the recovery page.
> >>
> >> "cpchan" <cpchaney@.netvigator.com> wrote in message
> >> news:46ff47de$1@.127.0.0.1...
> >> > Dear,
> >> >
> >> > How can I make a SQL Server able to send me an email alert if its SQL
> >> > Server
> >> > Service and/or SQL Server Agent Service is down automatically ?
> >> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because
they
> >> > can
> >> > monitor themselves.
> >> >
> >> > Are there any other way to monitor them ? Either from Microsoft
Windows
> >> > system or third party softwares.
> >> >
> >> >
> >>
> >>
> >
> >
>|||Or (the poor man's approach) you can also write a WMI script using VBScript
that monitors the SQL Server service and sends an email when it goes down.
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ffb47d$1@.127.0.0.1...
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Od9MKe2AIHA.288@.TK2MSFTNGP02.phx.gbl...
>> > What does MOM stand for ?
>> Microsoft Operations Manager. See
>> http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
>>
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:46ffa2bc$1@.127.0.0.1...
>> > Dear Yudkin,
>> >
>> > What does MOM stand for ?
>> > Please tell me, thanks a lot.
>> >
>> > "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
>> > news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
>> >> The simplest solution is to configure MOM (assuming you have deployed
>> >> it).
>> >>
>> >> Otherwise you need to do this in Windows. In the Computer Management -
>> >> Services node, display the properties pages of the services of
>> >> interest
>> > and
>> >> configure the recovery page.
>> >>
>> >> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> >> news:46ff47de$1@.127.0.0.1...
>> >> > Dear,
>> >> >
>> >> > How can I make a SQL Server able to send me an email alert if its
>> >> > SQL
>> >> > Server
>> >> > Service and/or SQL Server Agent Service is down automatically ?
>> >> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because
> they
>> >> > can
>> >> > monitor themselves.
>> >> >
>> >> > Are there any other way to monitor them ? Either from Microsoft
> Windows
>> >> > system or third party softwares.
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>

How can I grab a notification email address from a job?

Is there a handy-dandy way for me to be able, from a stored procedure, to capture the notification email address for a user associated with a job?

I need to send an email out from a stored procedure, and I want it to be set up to send to the same user that is set up in the job that calls the stored procedure.

the same notification stored proc will be used in multiple jobs, but the jobs are already set up with a notification email to be sent to the defined users "on completion" (error or not). I want a separate email to be sent, but I want to use xp_Sendmail because I have to perform a select who's output I want to appear in the body of the email (and unless I am missing something, I have no control over the body of the standard "job completion" email).

I would prefer to NOT have to "hard code" the user email address in the stored proc that calls xp_sendmail, OR to put it in some user table in the database, when the user I want to send it to will always be the same one defined in at the JOB level in Enterprise Manager.

Any thoughts? Thanks in advance for your instantaneous and informative answer-packed responses! ;)I'm shooting from the hip on this, but I'd start with:SELECT j.name, o.email_address
FROM msdb.dbo.sysjobs AS j
LEFT JOIN msdb.dbo.sysoperators AS o
ON (o.id = j.notify_email_operator_id)-PatP|||That's what I was looking for, Oh Great One...

Or something to that effect...I obviously need to get more accustomed to the sys tables...but tried as many ways as I could think of to find a reference to something like that in BOL...but alas, apparently didn't know what to search for *L*

I guess I need to break down and read my SQL200 Unleashed book and learn a little about the architecture that is padding my paycheck *sigh*

As always, thanks for the gentle nudge ;)