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 notification

control flow something like this

Filewatcher -> sp_start_job ->onfailure ->email notification

Your help is highly appreciated

Thanks,
Chandra

__________________
Thanks,
Chandra