Trying to get my jobs to send mail when job fails. Should be easy but
it's giving me headache
Had a whole slew of issues. Outlook is installed with a n outlook
mail profile set up that can send mail in outlook. I can create a
SendMail DTS and execute it to send mail
Email works in these scenarios
1. I create a DTS package in SQL Server with just SendMail with the
same Profile "ABC" and click Execute and it sends
2. I can send using Outlook with the same profile "ABC"
3. I can run DTSRun with command prompt calliing the DTS package and
it sends fine
However it wont send in these 3 scenarios (where I need it!):
1. I go to Operator, and put my Profile "ABC" in the Email Name,
click Test and I get this error "Error 22022: SQLServerAgent Error:
The SQLSErverAgent mails ession is not running; check the mail profile
and/or the SQLServerAgent service startup account in the
SQLSErverAGent Properties
sQLServer Agent is running
2. If I add the DTS Package "EmailTest" to one of my jobs as a step
to go to if the 1st step fails, nothing gets sent
3. In JObs -- Notificatioin, If I set the E-maill operator to my
operator, nothing gets sent
I set the Mail Profile to the Mail Profile (in SQL Server AGent'
properties)
However when I click Test, I get this error:
Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs it
references
I am using
SQLServer Version 8.00.194,
OS Windows 2003
Help!
3  3453 
Maybe u should post this query to an SQL Server newsgroup! What are doin here?
On 11 Nov 2004 07:04:29 -0800, Achilles wrote: Maybe u should post this query to an SQL Server newsgroup! What are doin here?
Maybe you should look around yourself at your surroundings. Or at least at
the headers.
From: ac************* *@rediffmail.co m (Achilles)
Newsgroups: comp.databases. ms-sqlserver
Subject: Re: SQLMail woes !
On 10 Nov 2004 16:01:18 -0800, Angel Cat wrote: Trying to get my jobs to send mail when job fails. Should be easy but
it's giving me headache
Had a whole slew of issues. Outlook is installed with a n outlook
mail profile set up that can send mail in outlook. I can create a
SendMail DTS and execute it to send mail
Email works in these scenarios
1. I create a DTS package in SQL Server with just SendMail with the
same Profile "ABC" and click Execute and it sends
2. I can send using Outlook with the same profile "ABC"
3. I can run DTSRun with command prompt calliing the DTS package and
it sends fine
However it wont send in these 3 scenarios (where I need it!):
1. I go to Operator, and put my Profile "ABC" in the Email Name,
click Test and I get this error "Error 22022: SQLServerAgent Error:
The SQLSErverAgent mails ession is not running; check the mail profile
and/or the SQLServerAgent service startup account in the
SQLSErverAGent Properties
sQLServer Agent is running
2. If I add the DTS Package "EmailTest" to one of my jobs as a step
to go to if the 1st step fails, nothing gets sent
3. In JObs -- Notificatioin, If I set the E-maill operator to my
operator, nothing gets sent
I set the Mail Profile to the Mail Profile (in SQL Server AGent'
properties)
However when I click Test, I get this error:
Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs it
references
It sounds as if possibly you have set up the Outlook profile while logged
in as yourself, instead of while logged in as the SQLAgent user. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mark |
last post by:
O, woe is me, to have seen what I have seen, see what I see!
(That's Shakespeare for those who were wondering what I'm on about)
I am "having fun" with cookies.
And I wonder if I have missed something obvious.
|
by: Cedric |
last post by:
This is a 3 weeks old problem, but having found a solution (and having
looked for one here, finding only this message), I'm replying now.
From: Jive (someone@microsoft.com)
Subject: Upgrade woes: Numeric, gnuplot, and Python 2.4
Date: 2004-12-11 18:45:10 PST
> Here's my sitch:
>
> I use gnuplot.py at work, platform Win32.
> I want to upgrade to Python 2.4.
|
by: Andrew Thompson |
last post by:
- NN 4.78 rendering woes, links at far left -
I am trying to rework an old site, make it valid html
and css, improving the x-browser and 'older browser'
compatibility. My efforts so far, have been abysmal.
See, for example, this screen shot of the very
simple home page, it is not even 10% finished,
but I have already run into problems.
http://www.physci.org/test/xbrowser/nn478home01.png
|
by: Arun Bhalla |
last post by:
I'm having some inconsistency problems with my deployment project ("Setup")
and its custom actions ("Installer"). I'm using Visual Studio .NET 2003
(.NET 1.1, no service pack) on Windows XPSP1.
My main project is a band object (Explorer Bar) in an assembly (.DLL) that
needs to be registered on installation and unregisted on uninstallation. In
addition, during installation, Setup creates registry subkeys, sets registry
values, installs...
|
by: matthewalbum |
last post by:
I am using SQLServer2000 with sp3.
The SQLServer logs on as user Test on the local computer. I am logged
on as user Test on the local computer.
I have created a Exchange Profile and tested that it can send and
receive mail.
When I go to Enterprise Manager to set-up this profile for SQL Mail.
There is nothing in the drop-down list box.
| | |
by: Mark Rae |
last post by:
Hi,
This time, I'm looking for a regular expression which says "the string must
contain exactly seven or exactly eight digits" e.g.
123456 fails
1234567 passes
12345678 passes
123456789 fails
|
by: hdogg |
last post by:
Scope Woes - IF statement nested in WHILE statement -PHP
I have an array $actuals_sum.
<?php
while(conditions)
{
if($i == '24)
{
|
by: =?Utf-8?B?VkIgSm9ubmll?= |
last post by:
I am at my witless end here, please help!
I have an ASP.Net aspx web page, hosted on Windows Server 2003, that
receives a query string with the path to an autocad drawing file selected
from a web page hosted on a unix driven file server. The user wants to have
this file converted to a pdf.
My page takes the query string and turns it into a windows unc path, then I
copy the file down to the web server and place it into a directory. This...
|
by: Mike Howarth |
last post by:
I've been having a few problems with connecting to SQL Server, initially I
was using dblib however found some problems with returning text fields
whereby all text fields were ignored and it bawked at multiline sql
statements.
Having found these major stumbling blocks I've started using pymssql which
seems less flaky. One problem I've stumbled across is that I seem to reach
my max connections on the database fairly easily (given how my...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
