Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Have Job Ignore Error

Status
Not open for further replies.
Imakeoil

Imakeoil

Programmer
Dec 20, 2008
38
US
I have a stored procedure that sends out and email. It runs fine in SSMS and sends the email, but when it runs as a job it fails. The error is 'can not convert nvarchar to real', which I have spent months trying to fix and can not figure out, since I can not find any nvarchar fields. So I would like to have the job ignore the error and send out the email anyway. This job works fine on the old sql 2000 server, but not on the new sql 2005 server. I have tried setting the job to 'Go to the next step' on error, but the job is only the one step 'Exec stored procedure'.

Any advice would be appreciated.
Thanks
 
Status
Not open for further replies.

Similar threads

Putch66
  • Locked
  • Question
Afternoon People Have created a da 1
Replies
1
Views
114
kray4660
kray4660
bordway
  • Locked
  • Question
Ref thread1462-1567557 I have t
Replies
0
Views
33
bordway
bordway
Jojo63
  • Locked
  • Question
I am new to SSRS. We have a repo
Replies
0
Views
36
Jojo63
Jojo63
deedv
  • Locked
  • Question
SSRS Parameter dropdown receiving error: Sys.WebForms.PageRequestManagerServer.
Replies
0
Views
76
deedv
deedv
This2willpass
  • Locked
  • Question
Error Converting Datatype varchar
Replies
1
Views
70
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top