General discussion

Locked

Create a Task in MSSql task Manager

By rheal.dugas ·
I want to create a task in MSSql DTS Manage that will Empty/clear a temp table, check another table and look at one of the fields, if that field is NULL, put a entry into the temp table for each of the entries that contains a NULL and send a email. The task is to be run every 45 mins.

I have been able to create the above but the hard part for me is if there are no NULL entries and after running the task the Temp table is empty I dont want a e-mail sent...

Can anyone shed some light on this

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Tony Hopkinson In reply to Create a Task in MSSql ta ...

Not sure if I'm understanding your problem correctly
but
Declare @NullCount int
Select @NullCount = (Select Count From #TempTable)
If @NullCount = 0 Then
....

Can't remember the name but there used to be a extended stored procedure for sending a mail.

Something like that anyway.

Collapse -

by rheal.dugas In reply to

Poster rated this answer.

Collapse -

by rheal.dugas In reply to Create a Task in MSSql ta ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums