Problem With SQL Server Job

Hi,
We have jobs successfully running on the server. Now we moved the server to a different IP address(still the same machine).
I modified the DTS which has been scheduled as a job. In the DTS I modified the server IP address. Now when I ran the job I am getting the error message as " DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
If I run the DTS itself it is working fine. But it is not working as a job.
But if I create a new job with the same DTS, the job runs fine without any error.
I have logged into the machine with my own user account.
Please some advise on this.

ThanksAre you trying to run the encrypted job that DTS created originally? If so, the GUID points to the previous version, not the one you modified. If you change the IP and let DTS create a new job, it should be OK. Or, manually create an uncrypted job with DTSRUN (details are in BOL).|||When you run it it runs under the context of your id, which has authority to right to the drives...

When it's scheduled it runs under the context of the sql server agents account, which does not have rights...

And because you made it an ip...it's leaving and coming back in to itself...and has to authenticate...

Grant the accounts the rights to the drive...|||Yes. I am running the encrypted job. But when I replaced this encrypted string with the new encrypted string (after I created the new job from the modified DTS), the job successfully ran.
If we use DTSRUN we need to provide the username and password in the code which will be seen by other users when they check the properties of the job.
So we are using the encrypted method.
If we want to user the encryption methodology, and if there are 100s of jobs, do we have to recreate each job from the DTS and replaced the encryption string or there is any easier method?
If we use DTSRUN method and if we provide username and password for sa in that string, will it be seen by otherusers when they try to open the job?

Thanks|||Is the SQLAgent a Windows user? If so, use the /E switch for a trusted connection.

Yes, you will have to create a new job for each encrypted string. Or script out one job, gather all the encrypted strings, and mass produce them.|||Does it have to be DTS?

Can't they be sprocs?

Or is it too late?sql

Problem with sending email

This is the first time I am setting up an operator so that I can get job
notifications to my email. When I create an operator any type in my address
and click test. It gives me the following error:
Problem occoured while attempting to resolve the address 'my email address'.
Mapi error code number -2147221233
ThanksThe first thing would be to check to ensure that SQL Mail has been setup
correctly as typically the MAPI errors occur as a result of an incorrect
configuration. The KB Article
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556 describes how
to Configure SQL Mail and the KB article
http://support.microsoft.com/kb/315886/EN-US/ details Common SQL Mail
Problems.
- Peter Ward
WARDY IT Solutions
"Amit" wrote:
> This is the first time I am setting up an operator so that I can get job
> notifications to my email. When I create an operator any type in my address
> and click test. It gives me the following error:
> Problem occoured while attempting to resolve the address 'my email address'.
> Mapi error code number -2147221233
> Thanks

Problem with 'Reply-To' in data driven subscription

I am running SQL Server 2000 sp4 and Reporting Services 2000 sp2. I set
up a data driven subscription with a static Reply-To address. However,
when the report runs, the reply is the default in the config file.
I've seen 1 other post on this but no solution. Help would be
appreciated.
NeilI captured this info using SQL Profiler:
exec CreateSubscription @.Report_Name =N'/WebInvoiceStatus_Reports/VendorActivity', @.id ='86750772-3D96-4059-8B1E-9F5F5D6C8000', @.OwnerSid =0x01050000000000051500000093E362480D7A5A33828BA628CA300100, @.OwnerName
= N'US\A0312698', @.OwnerAuthType = 1, @.Locale = N'en-US',
@.DeliveryExtension = N'Report Server Email', @.InactiveFlags = 0,
@.ExtensionSettings =N'<ParameterValues><ParameterValue><Name>TO</Name><Field>EmailAddress</Field></ParameterValue><ParameterValue><Name>ReplyTo</Name><Value>aphelp@.abcdef.com</Value>...
This shows that the value I wanted was being picked up. So I wonder if
the problem is with the smtp.
Neil|||My issue is not with the 'Reply-To' I just discovered.
It is the 'From' that I have been trying to change and that cannot be
done for each subscription.
The From did change when I changed it in the config file.
I love solving my own problems.
Neil