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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 08:19:08
|
| Robert writes "IS there a way to call an SQL job from within a stored procedure? What I am trying to do is send out an email when a database trigger is 'triggered' detailing what the updated record.Thoughts??" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-17 : 08:41:13
|
quote:
IS there a way to call an SQL job from within a stored procedure?
Yes, it can be found in books on line.quote:
Thoughts??
Yes. You should keep in mind that any processing that occurs in the trigger will extend the amount of time that the record is locked. If you have a high transaction system, you may want to insert into a mailqueue in your trigger and create your job to send mail out of the queue.<O> |
 |
|
|
|
|
|
Calling SQL Job within stored procedure or SQL statement