Scheduling approach

We user SQL sever 2005, I have a reports runs very slow since big chunk
of data, I just want to run it once a day. This report has few
selections fields, for different people they want to see different
selection criteria, is there a way I can just schedule it once for wide
open selection and each person based on this generic report to narrow
down to their own small set of data? thanksI use email to notify the end user for the "new" genereated report, but
why each time the user click the link, instead of giving the snapshot,
the link do the RE-Generat report? how do i let user only see the
snapshot, it is a big report.|||On the report options, set the execution to execute from a snapshot and set
the snapshot creation for a quiet time to avoid impacting OLTP. Then set up a
subscription to run when content is refreshed (available only for snapshot
reports). You will need to set up default parameters, but if chosen to return
NULL data, you effectively get an email with a notice of report content
update with a dummy report attached.
"Wang Xiaoning" wrote:
> I use email to notify the end user for the "new" genereated report, but
> why each time the user click the link, instead of giving the snapshot,
> the link do the RE-Generat report? how do i let user only see the
> snapshot, it is a big report.
>sql

schedule email function

Hi all,
I am looking for scripts or method could use sql sever periodaically send
out emails to alert users according to the particular time log setting.
Thx in advance,
Fox NewbiewHi Fox,
What do you want to send ? Which version are you using ? (I am asking,
becasue there had been some changes within the SQL Mail in 2k5)
Are you able to install a MAPI profile on your server ? Is the server
running under the local system accoutn or a domain account ?
You see, you need to provide some more information first ;-)
HTH, Jens Suessmeyer.|||I would like to send out html format email to users to alert them in
periodically. I am using W2k sp4 and is running as domaint account.
I would go for with or without MAPI solution are both welcome.
Thx so much
"Jens" wrote:
> Hi Fox,
>
> What do you want to send ? Which version are you using ? (I am asking,
> becasue there had been some changes within the SQL Mail in 2k5)
> Are you able to install a MAPI profile on your server ? Is the server
> running under the local system accoutn or a domain account ?
> You see, you need to provide some more information first ;-)
> HTH, Jens Suessmeyer.
>|||I'd download and use xp_smtp_sendmail from www.sqldev.net.
In 2005, SMTP support and HTML are built-in to the new "Database Mail" functionality.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
news:F09A5612-B171-4402-A213-08C91A4D1C8B@.microsoft.com...
>I would like to send out html format email to users to alert them in
> periodically. I am using W2k sp4 and is running as domaint account.
> I would go for with or without MAPI solution are both welcome.
> Thx so much
> "Jens" wrote:
>> Hi Fox,
>>
>> What do you want to send ? Which version are you using ? (I am asking,
>> becasue there had been some changes within the SQL Mail in 2k5)
>> Are you able to install a MAPI profile on your server ? Is the server
>> running under the local system accoutn or a domain account ?
>> You see, you need to provide some more information first ;-)
>> HTH, Jens Suessmeyer.
>>|||Does it possible not using SQL mail ? Since I have an retriction on not allow
install outlook, once outlook missing SQL mail is not workable.
"Tibor Karaszi" wrote:
> I'd download and use xp_smtp_sendmail from www.sqldev.net.
> In 2005, SMTP support and HTML are built-in to the new "Database Mail" functionality.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
> news:F09A5612-B171-4402-A213-08C91A4D1C8B@.microsoft.com...
> >I would like to send out html format email to users to alert them in
> > periodically. I am using W2k sp4 and is running as domaint account.
> >
> > I would go for with or without MAPI solution are both welcome.
> >
> > Thx so much
> >
> > "Jens" wrote:
> >
> >> Hi Fox,
> >>
> >>
> >> What do you want to send ? Which version are you using ? (I am asking,
> >> becasue there had been some changes within the SQL Mail in 2k5)
> >>
> >> Are you able to install a MAPI profile on your server ? Is the server
> >> running under the local system accoutn or a domain account ?
> >>
> >> You see, you need to provide some more information first ;-)
> >>
> >> HTH, Jens Suessmeyer.
> >>
> >>
>
>|||Hi Fox,
Your are right. It is a SMTP based extended procedure to send emails.
The only restriction which perhaps might keep you away from using it,
is that i can=B4t autenticate at a SMTP server, so the smtp server has
to accept only non authenticated users. But as a workaround you can
also specify a virtual SMPT Server (which is part of every Windows 2k >
version), which relay the mails to the secure server WITH
authentication.
HTH, jens Suessmeyer.|||None of the two I mentioned uses MAPI, i.e., they do not require Outlook.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
news:B52620EA-0055-4B0D-94E0-A597C2B19367@.microsoft.com...
> Does it possible not using SQL mail ? Since I have an retriction on not allow
> install outlook, once outlook missing SQL mail is not workable.
> "Tibor Karaszi" wrote:
>> I'd download and use xp_smtp_sendmail from www.sqldev.net.
>> In 2005, SMTP support and HTML are built-in to the new "Database Mail" functionality.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
>> news:F09A5612-B171-4402-A213-08C91A4D1C8B@.microsoft.com...
>> >I would like to send out html format email to users to alert them in
>> > periodically. I am using W2k sp4 and is running as domaint account.
>> >
>> > I would go for with or without MAPI solution are both welcome.
>> >
>> > Thx so much
>> >
>> > "Jens" wrote:
>> >
>> >> Hi Fox,
>> >>
>> >>
>> >> What do you want to send ? Which version are you using ? (I am asking,
>> >> becasue there had been some changes within the SQL Mail in 2k5)
>> >>
>> >> Are you able to install a MAPI profile on your server ? Is the server
>> >> running under the local system accoutn or a domain account ?
>> >>
>> >> You see, you need to provide some more information first ;-)
>> >>
>> >> HTH, Jens Suessmeyer.
>> >>
>> >>
>>|||Tibor,
Correct me if i got wrong, since I get down to www.sqldev.net and only find
xp_smtp_sendmail use xp_sendmail as well and xp_send mail from SQL mail and I
need to install outlook on production server and as admin acccount to send
out mails, which I am not allowing to install any outlook kind of programs on
production server.
Any alter suggestions on schdule a job to send out mail at periodically ?
Thx in advance !
Best Regards,
Fox
"Tibor Karaszi" wrote:
> None of the two I mentioned uses MAPI, i.e., they do not require Outlook.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
> news:B52620EA-0055-4B0D-94E0-A597C2B19367@.microsoft.com...
> > Does it possible not using SQL mail ? Since I have an retriction on not allow
> > install outlook, once outlook missing SQL mail is not workable.
> >
> > "Tibor Karaszi" wrote:
> >
> >> I'd download and use xp_smtp_sendmail from www.sqldev.net.
> >>
> >> In 2005, SMTP support and HTML are built-in to the new "Database Mail" functionality.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
> >> news:F09A5612-B171-4402-A213-08C91A4D1C8B@.microsoft.com...
> >> >I would like to send out html format email to users to alert them in
> >> > periodically. I am using W2k sp4 and is running as domaint account.
> >> >
> >> > I would go for with or without MAPI solution are both welcome.
> >> >
> >> > Thx so much
> >> >
> >> > "Jens" wrote:
> >> >
> >> >> Hi Fox,
> >> >>
> >> >>
> >> >> What do you want to send ? Which version are you using ? (I am asking,
> >> >> becasue there had been some changes within the SQL Mail in 2k5)
> >> >>
> >> >> Are you able to install a MAPI profile on your server ? Is the server
> >> >> running under the local system accoutn or a domain account ?
> >> >>
> >> >> You see, you need to provide some more information first ;-)
> >> >>
> >> >> HTH, Jens Suessmeyer.
> >> >>
> >> >>
> >>
> >>
> >>
>|||xp_smtp_sendmail does *not* use xp_sendmail. Where did you read that?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
news:4FE4D1D2-EA6F-47A3-B8E4-178003E7BCEA@.microsoft.com...
> Tibor,
> Correct me if i got wrong, since I get down to www.sqldev.net and only find
> xp_smtp_sendmail use xp_sendmail as well and xp_send mail from SQL mail and I
> need to install outlook on production server and as admin acccount to send
> out mails, which I am not allowing to install any outlook kind of programs on
> production server.
> Any alter suggestions on schdule a job to send out mail at periodically ?
> Thx in advance !
> Best Regards,
> Fox
> "Tibor Karaszi" wrote:
>> None of the two I mentioned uses MAPI, i.e., they do not require Outlook.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
>> news:B52620EA-0055-4B0D-94E0-A597C2B19367@.microsoft.com...
>> > Does it possible not using SQL mail ? Since I have an retriction on not allow
>> > install outlook, once outlook missing SQL mail is not workable.
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> I'd download and use xp_smtp_sendmail from www.sqldev.net.
>> >>
>> >> In 2005, SMTP support and HTML are built-in to the new "Database Mail" functionality.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
>> >> news:F09A5612-B171-4402-A213-08C91A4D1C8B@.microsoft.com...
>> >> >I would like to send out html format email to users to alert them in
>> >> > periodically. I am using W2k sp4 and is running as domaint account.
>> >> >
>> >> > I would go for with or without MAPI solution are both welcome.
>> >> >
>> >> > Thx so much
>> >> >
>> >> > "Jens" wrote:
>> >> >
>> >> >> Hi Fox,
>> >> >>
>> >> >>
>> >> >> What do you want to send ? Which version are you using ? (I am asking,
>> >> >> becasue there had been some changes within the SQL Mail in 2k5)
>> >> >>
>> >> >> Are you able to install a MAPI profile on your server ? Is the server
>> >> >> running under the local system accoutn or a domain account ?
>> >> >>
>> >> >> You see, you need to provide some more information first ;-)
>> >> >>
>> >> >> HTH, Jens Suessmeyer.
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||You are right ! Thx
"Tibor Karaszi" wrote:
> xp_smtp_sendmail does *not* use xp_sendmail. Where did you read that?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
> news:4FE4D1D2-EA6F-47A3-B8E4-178003E7BCEA@.microsoft.com...
> > Tibor,
> >
> > Correct me if i got wrong, since I get down to www.sqldev.net and only find
> > xp_smtp_sendmail use xp_sendmail as well and xp_send mail from SQL mail and I
> > need to install outlook on production server and as admin acccount to send
> > out mails, which I am not allowing to install any outlook kind of programs on
> > production server.
> >
> > Any alter suggestions on schdule a job to send out mail at periodically ?
> >
> > Thx in advance !
> >
> > Best Regards,
> > Fox
> >
> > "Tibor Karaszi" wrote:
> >
> >> None of the two I mentioned uses MAPI, i.e., they do not require Outlook.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
> >> news:B52620EA-0055-4B0D-94E0-A597C2B19367@.microsoft.com...
> >> > Does it possible not using SQL mail ? Since I have an retriction on not allow
> >> > install outlook, once outlook missing SQL mail is not workable.
> >> >
> >> > "Tibor Karaszi" wrote:
> >> >
> >> >> I'd download and use xp_smtp_sendmail from www.sqldev.net.
> >> >>
> >> >> In 2005, SMTP support and HTML are built-in to the new "Database Mail" functionality.
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "Fox newbiew" <Foxnewbiew@.discussions.microsoft.com> wrote in message
> >> >> news:F09A5612-B171-4402-A213-08C91A4D1C8B@.microsoft.com...
> >> >> >I would like to send out html format email to users to alert them in
> >> >> > periodically. I am using W2k sp4 and is running as domaint account.
> >> >> >
> >> >> > I would go for with or without MAPI solution are both welcome.
> >> >> >
> >> >> > Thx so much
> >> >> >
> >> >> > "Jens" wrote:
> >> >> >
> >> >> >> Hi Fox,
> >> >> >>
> >> >> >>
> >> >> >> What do you want to send ? Which version are you using ? (I am asking,
> >> >> >> becasue there had been some changes within the SQL Mail in 2k5)
> >> >> >>
> >> >> >> Are you able to install a MAPI profile on your server ? Is the server
> >> >> >> running under the local system accoutn or a domain account ?
> >> >> >>
> >> >> >> You see, you need to provide some more information first ;-)
> >> >> >>
> >> >> >> HTH, Jens Suessmeyer.
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
>