Re: Automated DTS package will not run
From: Olu Adedeji (anonymous_at_email.com)
Date: 02/13/04
- Next message: Shannon: "set proxy account in SQL Server"
- Previous message: Olu Adedeji: "Re: rights to view/change jobs"
- In reply to: Schoo: "Re: Automated DTS package will not run"
- Next in thread: Baisong Wei[MSFT]: "Re: Automated DTS package will not run"
- Reply: Baisong Wei[MSFT]: "Re: Automated DTS package will not run"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 13 Feb 2004 22:19:55 -0000
questions are
1) who is the owner of the job
if owner of job is member of sysadmins fixed serverrole then job will run
dts in job owner's context
if owner of the job is not member of sysadmins then job will attempt to run
in sqlproxyaccount's context(if sql proxy account is configured) if not you
will get a failure
-- Olu Adedeji "Schoo" <scott.schuman@nospam.ma-hc.com> wrote in message news:OEcdtEm8DHA.4044@tk2msftngp13.phx.gbl... > Thank you for your response... perhaps I was not clear enough on what is > happening. All of the items you mention in regards to changing a schedule, > I am aware of. I am saying that the actual job starts, fails and I get an > email notifying me that the job fails (see original email in this string). > The issue is not how to run the job automatically or how to get it to email > me. The issue is that the DTS package will run fine if I open it up and > execute it, but not if I create a job and try to run it automatically. My > questions is: how can I get the DTS package (that runs manually without > errors) to run without errors automatically. > > I hope this is more clear and also that you might shine some light on this > issue for us. > > Scott > > "Baisong Wei[MSFT]" <v-baiwei@online.microsoft.com> wrote in message > news:S0TW5ug8DHA.1992@cpmsftngxa07.phx.gbl... > > Hi Scott, > > > > Thank you for using the newsgroup and it is my pleasure to help you with > > your issue. > > > > From the information you provided. since you got the email notification, > > the job runs and you the notification is working fine. For the job to run > > automatically, could you check the job schedule. You could right-click the > > job, then choose 'properties'; In the 'Schedule' tab, you will notice the > > schedule of how you job runs. If you want to change the schedule, you > could > > press the 'Edit' button. You could arrange a new schedule of the job, Then > > the job will run automatically. You could confirm by right-click the job > > and choose the 'View job history' and check the record of how the job > runs. > > For the 'Notification' button, you could check the 'Email operator', > choose > > one operator and select when to send the email notification. > > > > Hope this helps. If you still have questions, please feel free to post > your > > message here and I am ready to help! > > > > Best regards > > > > Baisong Wei > > Microsoft Online Support > > ---------------------------------------------------- > > Get Secure! - www.microsoft.com/security > > This posting is provided "as is" with no warranties and confers no rights. > > Please reply to newsgroups only. Thanks. > > > > > >
- Next message: Shannon: "set proxy account in SQL Server"
- Previous message: Olu Adedeji: "Re: rights to view/change jobs"
- In reply to: Schoo: "Re: Automated DTS package will not run"
- Next in thread: Baisong Wei[MSFT]: "Re: Automated DTS package will not run"
- Reply: Baisong Wei[MSFT]: "Re: Automated DTS package will not run"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
