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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2008-09-29 : 09:39:47
|
| Hi,I'm calling a "Execute SQL Task" which invokes a job (sp_start_job). Is there any way to track whether the job succeeded or failed as on the execution of job is always successful in my case whenever the job resides in the system but the job may fail when there is a problem in importing the flat file.I have to track down the failure of the job and based on that i need to send an email notificationcontrol flow something like thisFilewatcher -> sp_start_job ->onfailure ->email notificationYour help is highly appreciated |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-29 : 09:46:24
|
| You can use Send mail task or setup notification in SQL Server agent-job-Notifications.You have to have Dbmail configured. |
 |
|
|
|
|
|
work flow -design