Showing posts with label disabled. Show all posts
Showing posts with label disabled. Show all posts

Thursday, March 22, 2012

email subscriptions disabled

What options do I have if email subscriptions on my companies report server have been disabled. I need to run a report daily which will send to a list of receipents. The email feature would be perfect for this but our company (10000+ people) do not want our email systems clogged with big reports.

Hi,
you can enable email subscription modifying RsReportServer.config :
...............
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>YOUSMTPSERVER</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName>AAAA</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
........
Then, in email subscription configuration (http://localhost/reports....)
you check that the email sent contains link to report.

Friday, March 9, 2012

EM: Jobs: Runnable column

Hi,
I havent been able to figure out when a job is marked as not runnable.
I have several jobs, some enabled, some disabled, but they are all marked
as runnable.
Someone who can tell?A job without any jobsteps isn't runnable.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns96FE6969F3064gurbaohotmailcom@.129.250.171.66...
> Hi,
> I havent been able to figure out when a job is marked as not runnable.
> I have several jobs, some enabled, some disabled, but they are all marked
> as runnable.
> Someone who can tell?