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 |
|
rafeequddin_ahmed
Starting Member
23 Posts |
 Posted - 2008-07-16 : 12:21:00
|
| HI,I am working on a task that is sending email using Sql Server.I did the following steps.1.Enable the options for sending mail2.I have created Profile and account using the Sql Server Managment studio3.I wrote an store procedure to send mail ,in this i used db_sp_sendmail and I specified the profile i create for sp_send_dbmail it is working fine.4.I created a job and in this jop wrote the sript likeexec spnameIt is working fine.Now i have to do it on production server,but as I always give to script to give release but how can i generate script for JOb which i created using Sql Server managment ,as I got script to generate Profile and account from this link http://articles.techrepublic.com.com/5100-10878_11-6161839.html#.any help will be appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-16 : 14:18:18
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95018 |
 |
|
|
|
|
|
How to get Script for Job Created by Studio