February 25, 2021 at 12:54 pm
Hi all,
I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.
I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not).
Could you help me?
Thanks
February 25, 2021 at 1:06 pm
What sort of help do you want?
Hi all,
I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.
I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not). Could you help me? Thanks
What sort of help do you want?
What is an 'alter to' e-mail?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
February 25, 2021 at 6:09 pm
What sort of help do you want?
christi1711 wrote:Hi all,
I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.
I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not). Could you help me? Thanks
What sort of help do you want?
What is an 'alter to' e-mail?
Very much seems like a typo for 'alert to e-mail'.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
February 25, 2021 at 6:11 pm
Are you using SQL mail (sp_send_dbmail)? If so, you can use the mail status table in msdb to check on the status of any email. Look at the "sysmail_%" views.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply