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 - 2004-01-26 : 07:20:51
|
| Suket writes "Well i get a lot of emails with files and have to manually put the files in folders and then run jobs to load all the data.i have heard that Sql jobs can be trigerred from the windows application log and wanted to know if its possible that when i get a mail with the file the exchange server write to the windows application log and the entry in the log trigerrs my sql jobs based on file names" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-01-26 : 08:21:06
|
| If you do get a lot of files in emails, triggering the job might not be such a good idea as you could end up with too many jobs executing small requests. You'd be better off scheduling the job to run periodically, checking for new mails and parsing all the new files in one go.OS |
 |
|
|
|
|
|
Executing SQl jobs from the windows log