Eric Barro
ebarro at verizon.net
Tue Jun 12 12:36:50 CDT 2007
1. So the DTSX package runs on your machine when you run it right? 2. The scheduled job fail when you manually run it and when it is scheduled to run? I would go check the following: 1. Context under which the scheduled job is run. In other words, what login is the job using when it runs? 2. Is RBWZP4051 your machine name? 3. In both instances, you are running it from your machine right? -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Elizabeth.J.Doering at wellsfargo.com Sent: Tuesday, June 12, 2007 9:00 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Scheduling DTSX packages in SQL Server 2005 Thanks for the suggestion, Eric. Here's the details: Date 6/12/2007 8:21:04 AM Log Job History (ImportJM) Step ID 0 Server RBWZP4051 Job Name ImportJM Step Name (Job outcome) Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message The job failed. The Job was invoked by User AD-ENT\elizabeth.j.doering. The last step to run was step 1 (Step1). There is only one step. I have a DateImported field in the table, which defaults to getdate(). It's not getting updated. Liz -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Eric Barro Sent: Tuesday, June 12, 2007 10:49 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Scheduling DTSX packages in SQL Server 2005 Check show details to see why it's failing. You're just skimming the surface when you view job history. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Elizabeth.J.Doering at wellsfargo.com Sent: Tuesday, June 12, 2007 8:33 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Scheduling DTSX packages in SQL Server 2005 Dear List, I have created a perfectly nice dtsx package which moves data from a table in one database on a server (running SQL Server 2000) to an identical table on another server running SQL Server 2005. When I save the package to my desktop and double click on it, it runs perfectly. Because it's from 2000 to 2005, I don't have the option to do this in 2000. When I schedule that package to run every hour, it fails. On the hour and when I randomly click on it and "Start Job at Step". I have done everything I can think of to make the nasty thing run, but all it reports in History is "The job failed. The Job was invoked by User AD-ENT\elizabeth.j.doering. The last step to run was step 1 (Step1)." This is beginning to feel rather personal here, like the server gods have it in for User AD-ENT\elizabeth.j.doering, i.e, me. I've done everything I can think of, but that was a short list, mostly involving rescheduling the package. I've also torn my hair and jumped up and down, but those don't seem to help either. Ideas, anyone? Thanks, Liz Liz Doering elizabeth.j.doering at wellsfargo.com 612.667.2447 This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007 6:39 AM _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007 6:39 AM