SQL JOB

From: Shamim (shamim.abdul@railamerica.com)
Date: 02/18/03 

From: "Shamim" <shamim.abdul@railamerica.com>
Date: Tue, 18 Feb 2003 13:57:21 -0600

SQL SERVER 7.0

Hi All,

I created a SQL job which executes a Stored procedure. Inside Stored
procedure, I read server name and database name from a table and execute a
Dynamic SQL statement.We have around 10 servers with 40 plus database.If
connection to one of the server/database fails, my JOB fails..

Is there any better approach/idea to tackle this issue..??

Thanks

Shamim

Relevant Pages

  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... I've installed a brand new copy of SQL Server 2000 with the original ... I've created the folowing stored procedure for the resync ... Resync Command: ALL_CUSTOMERS_RESYNC? ... I need to upgrade to a newer version of Microsoft SQL ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Tracing user & permissions (triggers and stored p)
    ... To solve my problem I chosed to configure the SQL ... > from xp_cmdshell executes under the security context of the SQL Server ... >> sql Trigger executes a Stored Procedure passing it some variables. ...
    (microsoft.public.sqlserver.security)
  • Re: Creating a database
    ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
    ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: Breakpoints in T-SQL not hit from VS 2005 with SQL 2005
    ... Open stored procedure in server explorer and set breakpoint ... Run the procedure from SQL Server Management Studio ... SQL Server 2005 Developer Edition installed on local PC. ... I created a windows project and called stored procedure using ...
    (microsoft.public.vsnet.debugging)
Loading