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 |
|
vsoneta
Starting Member
1 Post |
 Posted - 2009-08-17 : 16:31:32
|
| Hello,Can anyone please help me how can I acieve this ie. if the Job scheduled retries r completed then it should send an email as well as if any failure. I have it configured it for when an failure occurs but for retries, please help me. |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 06:25:49
|
| AFAIK there is no event raised when a retry occurs. If no event is raised, then you cannot trap for it. I haven't looked in WMI for such so it's possible that it exists there.If you absolutely have to know (and I question why you care since we generally want PASS or FAIL in a job), then you'll likely end up having to write multiple steps that use NO retry but have the same code and then change the On Success action to jump to the next logical step in your job.========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
 |
|
|
|
|
|
3) don’t send out an email warning unless the max