Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asmi
Starting Member
2 Posts |
 Posted - 2008-09-11 : 02:42:54
|
| How to auto execute the SP at start of every month?I want to auto generate the reports and mail it to the given mail id.To generate the reports and mail it, I have my SQL querries and the mailing id also. I can create the SP which will return me resultset for reports but how do I ensure that the SP is auto executed every month without fail.Or is there any other way I can do it? |
|
|
ranganath
Posting Yak Master
209 Posts |
Posted - 2008-09-11 : 02:46:37
|
| Hi,using Job scheduling |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-11 : 02:47:32
|
schedule it via SQL Server Agent
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
asmi
Starting Member
2 Posts |
Posted - 2008-09-11 : 03:00:59
|
| Any help on how to use SQL Server agent or Job scheduling |
|
|
|
ranganath
Posting Yak Master
209 Posts |
|
|
|
|
|
How to auto execute the SP at start of every month