| Author |
Topic |
|
scotchbroom
Starting Member
17 Posts |
 Posted - 2004-03-30 : 09:46:52
|
| I have tried using the wizard to create and schedule local DTS packages to run weekly at 5 am on Fridays and notify me upon completion. Every week both parts of the task fail: the execution and the email. I have checked the properties. The schedule and job are enabled. The error message on one is: "The job failed. The Job was invoked by Schedule 57 (Friday CompanyName). The last step to run was step 1 (Friday CompanyName). NOTE: Failed to notify 'me' via email."The jobs execute fine when done manually. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-30 : 10:12:55
|
| The job needs to be owned by sa or the owner of the DTS package. Can you send any notifications to the operator you are using for your job?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-30 : 11:03:08
|
| None of the notifications have worked. As of now, I am the only contact in the Operators. I am the owner of the local DTS packages.Do I have to create an sa Operator and then change the owner of the packages? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-30 : 12:19:43
|
| Then make sure you also own the job. You need to configure your mail correctly.--Log in as account running SQL Server.--Log into Outlook, set it up as default mail, and point to your mailbox.--Log into SQL Server, right click on server, and choose properties.--Set up mail profile.--Right-click on SQL Agent and set up mail profile.--Restart SQL Agent. Test the email.--Test a job that sends email to you as the operator.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-30 : 12:48:50
|
Under Server Settings, the SQL Main field is grey and disabled. My Outlook runs on my network login.  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-30 : 12:50:33
|
| http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-30 : 14:31:03
|
| Is SQL Server running under your account also, or another account? Look under Control Panel/Services. it's MSSQLServer and SQL Server Agent.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-30 : 14:34:35
|
| I see MSSQLAgent$MICROSOFTBCM and SQLAgent$MICROSOFTBCM listed in Services.Does the email configuration part have any bearing on why the job won't run as scheduled? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-30 : 15:18:53
|
| Doesn't the job execute but error out? Your last question confuses me. The error most likely has to do with e-mail not being configured. Did you follow the steps in the link that I posted?Tara |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-30 : 15:25:06
|
| tduggan,I have that article open right now as I multi-task with several other things. My problem is that I need to install or configure SQLMail on my 'SQLserver2' and then program DTS packages to email me when they complete successfully or fail. My DTS packages don't run on schedule (Problem #1) and I can't figure out how to set up SQLMail (Problem #2). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-30 : 15:36:16
|
| Is the SQLSERVERAGENT service started? Is it configured to use a domain account that has local admin privileges? Problem #2 is described in the link.Tara |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-30 : 15:42:20
|
| Nope. I can't figure any of it out. I've never written a sp before but I do have an example of one for mail that's extremely complicated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-30 : 15:45:19
|
| Nope to what? The SQLSERVERAGENT service isn't started? Or is it configured to use a domain account that has local admin privileges? The service needs to be started in order to run jobs. The service needs to use an account that has local admin privileges for SQL Mail.You don't need a stored procedure for this. You just setup SQL Mail, then modify the job notifications so that e-mails you.Tara |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-30 : 15:47:50
|
| No the service isn't started. How does it get set up? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-30 : 15:52:04
|
| Go to Control Panel, then to Administrative Tools. Go to services. Double click on SQLSERVERAGENT. Have the service automatically startup. Go to the logon tab. Have it use a domain account that has local admin privileges.Tara |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-31 : 08:26:22
|
| Morning, Tara & All:I went to Services as you said and only found SQLAgent$MICROSOFTBCM and MSSQLAgent$MICROSOFTBCM so I started SQLAgent$MICROSOFTBCM and set it to automatic. Not sure if that's the same as the one you mentioned. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-31 : 09:30:12
|
| Are all of those set to run under a domain account, or an account that has an exchange email?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-03-31 : 09:47:29
|
| It says Local. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-31 : 12:15:01
|
| You've got a named instance installed. Two services need to be started automatically. SQLAgent$MICROSOFTBCM and MSSQL$MICROSOFTBCM. Change the local system account option to a domain account that has local admin privileges. This is all discussed in that article I posted. Have you looked at it?Tara |
|
|
|
scotchbroom
Starting Member
17 Posts |
Posted - 2004-04-01 : 11:14:43
|
| Any idea how the domain\username login will be affected by a network that's passwords are set on expiration timers? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-01 : 12:16:13
|
| If the password expires, the use will still be able to get into SQL Server until they logout. After logging back into Windows, they will need to change their password. They will then be able to connect to SQL Server. It is transparent to SQL Server. It is handled at the Windows layer.Tara |
|
|
|
Next Page
|
DTS Scheduling fails