Re: How to log errors occured in nested packages

Thanks Simon.

"Simon Worth" <REMOVEFIRST_simon.worth@xxxxxxxxx> wrote in message
news:usELW2ROFHA.2144@xxxxxxxxxxxxxxxxxxxxxxx
> Well that's up to you really, but you would then be adding configuration
> and execution settings to a process execution log table. You'll want to
> split those things out for readability.
> example
> Config table
>
> CREATE TABLE [dbo].[ConfigSettings] (
> [ConfigId] [int] IDENTITY (1, 1) NOT NULL ,
> [SettingName] [nvarchar] (255) NOT NULL ,
> [SettingValue] [nvarchar] (2000) NOT NULL ,
> [ActiveStatus] [bit] NOT NULL,
> [InsertUser] [varchar] (50) NOT NULL CONSTRAINT
> [DF_ConfigSettings_InsertUser] DEFAULT (suser_sname()),
> [InsertDate] [datetime] NOT NULL CONSTRAINT [DF_ConfigSettings_InsertDate]
> DEFAULT (GETDATE()),
> [UpdateBy] [varchar] (50) NULL ,
> [UpdateDate] [datetime] NULL) ON [PRIMARY]
> GO
> Here you can hold all kinds of app settings or database settings to query
> during execution of packages to check states, file paths, etc.
>
> CREATE TABLE [dbo].[ImportProcessDetails] (
> [ProcessID] [int] IDENTITY (1, 1) NOT NULL ,
> [ProcessName] [varchar] (50) NOT NULL ,
> [ProcessDesc] [varchar] (150) NOT NULL ,
> [ProcessNotes] [varchar] (300) NULL ,
> [CreateUser] [varchar] (50) NOT NULL CONSTRAINT
> [DF_ProcessDetails_CreateUser] DEFAULT (suser_sname()),
> [CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ProcessDetails_InsertDate]
> DEFAULT (getdate())) ON [PRIMARY]
> GO
>
> Here you can log stored procedure results for support to review.
>
> Obviously you'd want to modify the above tables to meet your needs - as
> this is off the top of my head, but you get the idea. If you were to mix
> the 2 tables it would become confusing as you are mixing 2 very different
> types of data.
>
>
>
>
> Simon Worth
>
> Ray5531 wrote:
>> That's a nice idea (Having a config type Table to track packages
>> executions and other useful information).I can even use this table for my
>> stored procedure errors as well,how about that?
>>
>> Thanks simon
>> "Simon Worth" <REMOVEFIRST_simon.worth@xxxxxxxxx> wrote in message
>> news:%2363YtDIOFHA.3668@xxxxxxxxxxxxxxxxxxxxxxx
>>
>>>If you're using a config type table to hold settings for your
>>>application, I would add a setting in there that sets the flag of the dts
>>>package so that when the job executes it can check your config table to
>>>see if another instance is running (or at what step the package is at, or
>>>what step your stored proc is at etc). That way if package A starts it
>>>can check to see where the other job is at, and if conflicts can exit
>>>without issues.
>>>You can log stored procedure results (errors or other information) in a
>>>table for support to view at anytime. There is not built in mechanism
>>>for a stored procedure to log activity like a DTS package can. But you
>>>certainly can log critical information in tables for review.
>>>
>>>
>>>--
>>>Simon Worth
>>>
>>>Ray5531 wrote:
>>>
>>>>I forgot to ask about the second part of my original posting.
>>>>Thanks
>>>>"Simon Worth" <REMOVEFIRST_simon.worth@xxxxxxxxx> wrote in message
>>>>news:uRJojX7NFHA.3988@xxxxxxxxxxxxxxxxxxxxxxx
>>>>
>>>>
>>>>>Hi RayAll
>>>>>If package A calls package B, and package B runs past 10 minutes, then
>>>>>package A is executed again, that will instantiate a new package A (as
>>>>>the old package A is still waiting for Package B to complete), and the
>>>>>new package A will instantiate a new package B - you won't have
>>>>>conficts there. So far not a problem.
>>>>>But it depends on what your stored procedure "Bsp" is doing. There
>>>>>could be conflicts within the Bsp stored proc that would cause the spid
>>>>>for the orignal package B's bsp call to block the spid for the new
>>>>>package B bsp call. Something like original package B's BSP call is
>>>>>doing a massive update to a table, and new package B's Bsp call is
>>>>>trying to truncate the table - you could run into blocking processes
>>>>>ect.
>>>>>
>>>>>Do you really want package A to run again if the previous package A is
>>>>>still running from 10 minutes ago?
>>>>>
>>>>>Simon Worth
>>>>>
>>>>>RayAll wrote:
>>>>>
>>>>>
>>>>>>I have 2 packages called "A" and "B".
>>>>>>
>>>>>>Package "A" is schadulaed to be executed every 10 minutes and it is
>>>>>>supoosed to call Package "B".In package "B" I call an Stored procedure
>>>>>>called "Bsp".
>>>>>>
>>>>>>Here are my questions:
>>>>>>
>>>>>>1) Say that calling package "B" and it is running,10 minues is passes
>>>>>>and it's still working.Package "A" tries to call package "B" (but it
>>>>>>is still working).What happens?
>>>>>>
>>>>>>2) If there is any error occured in "Bsp" ,how can I log it some where
>>>>>>which next morning ,operator can figure out what has happened to the
>>>>>>packages .Is there a systable or something from which I can obtain
>>>>>>specific information about pachages whcih were supposed to be run at
>>>>>>schadules?
>>>>>>
>>>>>>
>>>>>>Thanks for your help.
>>>>>>Ray
>>>>
>>>>
>>


.

Relevant Pages

  • RE: Publish to External FrontPage Server
    ... meaning Auto config, use proxy I am able to connect to the remote website. ... How can I make this work without having to disable the IE settings everytime ... Publish to External FrontPage Server ...
    (microsoft.public.isa)
  • Re: Justified moaning?, I like to think so.
    ... I might have guessed you were going to ask for the steps to reproduce ... caching the settings for the current project and then either: ... Erroneously combining the new config with what's cached in some way ... new projects default to either Debug or Release and are those default ...
    (borland.public.delphi.non-technical)
  • Re: IPPhone provisioning in CE 6 R2
    ... the device will pickup and autoupdate the config. ... // check where we should get bootstrap server info from ... FTP server. ... But still the device didnt apply the settings as i think i had made ...
    (microsoft.public.windowsce.embedded)
  • Re: appsetting in class doesnt work
    ... configuration and putting application scope settings in the file by using ... First the config file: ... Public Sub SetTestsetting() ... of TestSetting in app config file ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Web service error - Client found response content type of text/html...
    ... takes long time to run, you're getting timeout error at client-side proxy, ... execution, there are three timeout settings you can take care: ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.webservices)