MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old June 24th, 2004, 08:13 AM
Carl Parker Carl Parker is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 21 Carl Parker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
SQL job fails

This job keeps failing with this event error:

SQL Server Scheduled Job 'Create Z File INS New LZI' (0xB1108DC65BCF494DA76C0A6B9F0A04FD) - Status: Failed - Invoked on: 2004-06-23 06:30:00 - Message: The job failed. The Job was invoked by Schedule 30 (Create Z File INS New LZI). The last step to run was step 1 (Create Z File INS New LZI).

Reply With Quote
  #2  
Old June 24th, 2004, 08:54 AM
timmyd timmyd is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 8 timmyd User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Can you tell us what the job does? If you don't know, you can find this information in Enterprise Manager under server_name -> Management -> SQL Server Agent -> Jobs. View the properties of the job you're having trouble with and click on the Steps tab. Find the step that's causing you trouble and click Edit.

If you have trouble figuring out what the problem is then post the code for us to see and we'll try to help you.

Tim Davis
The Hobbies of Tim Davis

Reply With Quote
  #3  
Old June 24th, 2004, 09:10 AM
Carl Parker Carl Parker is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 21 Carl Parker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
DTSRun /~Z0x726A52C65E1893CE2F39F1EDBE6D66AF6B273FC0B54B4B3F98C9262EC2A1EA106030F1608F83DE8E7E456F163D76F7D1 7B35D2F8A9E1FB028CEA5CCF9CE1829EA7E9D0629ADB4242F554D5A8C069263D1B18E12D3DEB72D4B208C437D2B1C2828998 7A283DA4C7231990E133FB40D49ADBDB8536BA556489B6C07BCE1CE3E9FEB2BCCDE702FFA7114675027246B20F03989ABE8D 65B91218F3C0B7EAA25C7AAC65D936430208C268FE7559DE41DBB22B659BA6

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > SQL job fails


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway