Re: Ignoring Errors

Check out the error handling sections of Erland's web site:
http://www.sommarskog.se/


--
Andrew J. Kelly SQL MVP


<googlemike@xxxxxxxxxx> wrote in message
news:1113236973.134465.132330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have some "best effort" jobs that try at various times to walk over
> missed records from one system to another about 5 times. After that,
> the data becomes stale and is no longer usable, so I have another
> process that comes after that to investigate the problem.
>
> The problem I'm having is that when my best effort jobs ran in MS SQL
> Server, they would run and then bomb out immediately. I want it instead
> to just continue on error.
>
> Meanwhile, I then switched the jobs to osql.exe and Task Scheduler this
> weekend. The results were exactly the same -- the job dies on error.
>
> Can you help me figure out a way either for osql.exe to continue on
> error, or for me to ignore all stored procedure errors and just keep on
> continuing?
>
> I'm used to VB's "on error resume next" and unfortunately I don't see
> one in MS SQL Server. This is absurd!
>


.

Relevant Pages

  • Re: procedure & function inside packages
    ... SQL> create table jobs ( ... SQL> CREATE OR REPLACE PACKAGE job_pkg IS ... SQL> CREATE OR REPLACE PACKAGE BODY job_pkg IS ... 'Chicken tickler') ...
    (comp.databases.oracle.server)
  • Re: DBA dissappointed in sql server 2005
    ... That's for NT logins only though. ... SQL Server MVP ... > going down to mangement and then sql server agent and then jobs looking at ...
    (microsoft.public.sqlserver.server)
  • Re: DBA dissappointed in sql server 2005
    ... I realize that a lot of>> improvements have been made in the programmers side of things, but I still>> have to manage the sql servers and I do not see any improvements in my day to>> day, week to week regular management task I have to perform. ... "testing">> or "production" database will only move the table definition and data, but>> not the underlying indexes or constraints. ... I need something that can show>> me easily the status of all jobs across all the servers without manually ... >> mayby others can enlighten me and point out some real benefits in the new>> sql server from a dba point of view. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL performance - multiple rows for SELECT (SQL0811)
    ... straightforward with SQL. ... SELECT aaa into:var from filea ... UPDATE fileb set xxx = 123 ... some high-volume batch jobs that have lots of embedded ...
    (comp.sys.ibm.as400.misc)
  • Re: procedure & function inside packages
    ... INSERT INTO jobs ... SQL> CREATE OR REPLACE PACKAGE job_pkg IS ... SQL> CREATE OR REPLACE PACKAGE BODY job_pkg IS ... 'Chicken tickler') ...
    (comp.databases.oracle.server)