.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Job notification

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I have an SSIS package which is scheduled to run daily using SQL agent. The SSIS package basically processes an SSAS cube. Once in a while, the job fails and the reason most of the times is due to the attributes missing in the dimension table. For example, one of the fact tables has account number as a column and it is joined to the account dimension by account number. Sometimes, new accounts get added to the fact table but those accounts don’t exist in the dimension table.

What we like to do is that when the SQL job fails, we want to know what attribute was missing that caused the cube to fail processing. An email is sent out to a group when the job fails and so it would be idea if we could include the missing attributes in that email. Any idea how to do this? Thanks in advance.


View Complete Post

More Related Resource Links

email notification error 5.1.1


 I am getting an error when sending email via asp.net.  The error is "Mailbox unavailable. The server response was: 5.1.1...User unknown."

However, the email is getting sent.  Why is asp.net returning this error?

I'm using VS 2008, vb.net,  running 2.0 framework.  This happens regardless of whether I'm testing my application from my local machine or running production version.  Also, I can send a batch of emails and get the error for some but not all.

I would like to be able to count of the error messages really being accurate, so this situation is unhelpful to our users, because they will start to just ignore all error messages.




SENS: System Event Notification Services and WMI Enable Flexible, Efficient Mobile Network Computing


Networked applications must deal with a host of connection problems ranging from timeouts to congestion to unavailability. If these applications can check the current connection status and, when disconnected, cache transmissions, they become more efficient. Fortunately, both the System Event Notification System (SENS) and Windows Management Instrumentation (WMI) can send notifications to keep applications informed of network status. In this article, the author explains the use of several SENS interfaces, including ISensNetwork and ISensLogon, which trigger events for connects/disconnects and logons/logoffs, respectively. The author then shows how you can subscribe to each of these events, and follows with a discussion of when you might use WMI events instead.

Aspi Havewala

MSDN Magazine August 2002

How to Customize the Add Comment 'Items on this list require content approval...' notification in


WSS 3.0:

If content approval is turned on, the Add Comment section displays a fairly ugly notification. Is there any way I can customize that section through e.g. CSS or SPDesigner?

I'd like to change at least the text, and preferably the yellow exclamation image, and also the background if possible.

Modify Subject line of Notification e-mails sent by Database Mail

Hello All, I am using database mail for SQL Server Agent Job notification.  It is working just great. However the e-mails that I receive have a specific format of subject line as below. SQL Server Job System: 'TEST' completed on \\Server_Name I wanted to see if I can modify this to send e-mails with this subject line. SQL Server Job System: 'TEST' completed on <Server_Name> Is this possible?  If so can someone help me with the steps? Thanks.

getting an e-mail notification when a transactional replication stucks

Hi all, I've SQL Server 2005 and a transactional replication scenario with one puplisher and 11 subscribers. Sometimes one of the subscriptions fails and a manual operation is required. Is there a way to get an e-mail notification whenever the replica fails or stucks or simply degrade its performances?

notification email not sent when updating a task programmatically

I have a task that's in the task list and has no value in the Assigned To field. When I update the field like this: listItem[SPBuiltInFieldId.AssignedTo] = SPContext.Current.Web.CurrentUser.ID; ListItem.Update(); The task is updated (the assigned to has filled in). But no notification has been send to the person in the assigned to. But when I change the assigned to manualy to another person, and then again to the person it was before, the notification is send. So the email works and the notifications are activated, why is there no notification sent when I change the assigned to programmatically?

How to make taskbar notification appear and disappear in asp.net web application

I want to make taskbar notification as like yahoo messenger or other messenger. When new message will come, from the taskbar small notification will appear as when new email come, yahoo do the same.   How I can make small taskbar notification in web application using asp.net? I want to notify if there is new record has come then from the taskbar notification will appear and after may be 2 minute it will be automatically disappear as like yahoo do.

ASP.Net - App Pool restarts because of file change notification

Hi All,IIS restarts everytime i delete a file. I came across this code which was supposed to fic the problem but the line f.GetValue(..) in last but one line returns null. Can anyone tell me why this is happening -//FIX disable AppDomain restart when deleting subdirectory//This code will turn off monitoring from the root website directory.//Monitoring of Bin, App_Themes and other folders will still be operational, so updated DLLs will still auto deploy.System.Reflection.PropertyInfo p = typeof(System.Web.HttpRuntime).GetProperty("FileChangesMonitor", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Static);object o = p.GetValue(null, null);System.Reflection.FieldInfo f = o.GetType().GetField("_dirMonSubdirs", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.IgnoreCase);object monitor = f.GetValue(o);System.Reflection.MethodInfo m = monitor.GetType().GetMethod("StopMonitoring", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic); m.Invoke(monitor, new object[] { });

Google Checkout Notification Page Not called

Hi All, I am implementing Google checkout in asp.net website. I done with all the checkout stuff. But I stuck in Notification page handler. My Notification aspx page is not get called. In sanbox integration console its showing 401 unauthorized access error. I tried many things but not succeeded yet. Can anyone help me to sort out this issue. Please don't refer google checkout page because I already spend lots of time on it to sort out this issue. Thanks in Advance Micky

Site FAQ: Email Notification Settings

There are several settings that come into play with email notifications coming from the ASP.NET forums:Edit Profile (http://forums.asp.net/user/EditProfile.aspx)1. Receive Emails: [ ] Yes  [ ] No - This is the master email switch. Setting this to [ ] No will prevent ALL forums-related emails from being sent to you, including password reset emails (if you find yourself in that situation, please use the site's Contact form to request password reset assistance).  Setting this back to [ ] Yes will allow emails to once again be sent to you.  This setting could be handy if you will be away from the ASP.NET Forums for a while and are not interested in receiving emails from the site while you are away.2. Receive rich (HTML) emails [ ] Yes [ ] No - This affects only the format in which emails are sent.  It has no bearing on whether or not emails are sent.  If [ ] No is chosen, the email will be sent in plain text.3. Enable Email Notifications of forum/thread subscriptions and replies to my posts. [ ] Yes  [ ] No - This is the default value of thread subscriptions. This value is checked only at the time of your first post to a thread, and the thread subscription is set to this value. Changing this value has no effect on any existing thread subscriptions. To discontinue (or start) receiving email notifications for a particular thread, see #5 below.&n

Persistant Status Bar Notification ... error 'SP.UI.Status' is null or not an object

I want to show a status bar that needs to be persistent on a page. for this I used the following in my master page function ShowStatusBarMessage(title, message) { var statusId = SP.UI.Status.addStatus(title, message, true); SP.UI.Status.setStatusPriColor(statusId, 'yellow'); /* Set a status-color */ } HTML, call the JS method: <a onclick="ShowStatusBarMessage('Title'!','Awesome message!')"> Display Status Bar message! </a> ref: http://www.zimmergren.net/archive/2010/03/17/sp-2010-dynamically-displaying-messages-to-your-users-with-the-notification-and-status-bar-areas-in-sharepoint-2010.aspx   But what I want is to call the function on load. So I used pushed ny function to _spBodyOnLoadWrapper using _spBodyOnLoadFunctionNames.push("YourFunctionName");, it throws an error 'SP.UI.Status' is null or not an object Next I created and deployed a webcontrol and did a registerclientscript, that too gives me 'SP.UI.Status' is null or not an object // Define the name and type of the client scripts on the page. String csname1 = "AlertScript"; Type cstype = this.GetType(); // Get a ClientScriptManager reference from the Page class. ClientScriptManager cs = Page.ClientScript; // Check to see if the startup script is already registered. if (!cs.IsStartupScriptRegistered(cstype, csname1)) {

proactive caching, sql server notification problem

I'll explain the problem with this simple example. I have a dimension and a fact table: CREATE TABLE [dbo].[Lead_Dim](   [Id] [int] NOT NULL,   [LeadSource] [nvarchar](50) NULL,   CONSTRAINT [PK_Lead_Dim] PRIMARY KEY ([Id]) ) GO CREATE TABLE [dbo].[Lead_Fact](   [Id] [int] IDENTITY(1,1) NOT NULL,   [LeadAmount] [float] NULL,   [Lead_Id] [int] NULL,   CONSTRAINT [PK_Lead_Fact] PRIMARY KEY ([Id]),   CONSTRAINT [FK_Lead_Fact_Lead_Dim] FOREIGN KEY([Lead_Id]) REFERENCES [dbo].[Lead_Dim] ([Id]) ) GO In the cube, I've enabled proactive caching for dimension and measure group partition. I use SQL Server notification (tracking table is 'Lead_Dim' for dimension and 'Lead_Fact' for measure group partition). Other properties are set to default (silence interval 10s,...). When I insert a record in the dimension and a record in fact like this: DECLARE @LeadId INT SET @LeadId = 1 INSERT INTO [Testing].[dbo].[Lead_Dim] ([Id], [LeadSource]) VALUES (@LeadId, N'Agent') INSERT INTO [Testing].[dbo].[Lead_Fact] ([LeadAmount], [Lead_Id]) VALUES (1.2, @LeadId) GO proactive caching processes both dimension and partition and cube measure is refreshed. But, when I run this: DECLARE @LeadId INT SET @LeadId =2 INSERT INTO [Testing].[dbo].[Lead_Dim] ([Id], [LeadSource]) VALUES (@LeadId, N'Agent') WAITFOR DELAY '00:00:02' INSERT INTO [Testing].[

Query Notification

Is there a way to get back information on the row that has changed when you subscribe for query notification.  Right now I just get back if the change was an update or insert.  Can I set it to send back the primary key of the change?     

Sharepoint 2010 WorkFlow Task AssignedTo Windows Group doesnt send email notification

Hi, Which configuration would prevent sharepoint to send a notification when a workFlow task is assigned to a Windows Group with an email ? The same task with a single User send a notification. Thanks, Patrice      

Notification not working on task assignment

Hello all, On a task list when "Read access" is set to "only their own", and you select "Yes" for "E-Mail Notification", the user is not being notified when a task is assigned to them. This was supposedly fixed in the Feb 2010 CU (see http://support.microsoft.com/kb/978396/en-gb) where it says... "You are no longer notified when a task is assigned to you. This issue occurs when you set Read access to Only their own." We're on the June 2010 CU and it doesn't seem to be fixed, or perhaps I'm missing something? I've found others who have this issue post Feb 2010 CU (see http://sharepointalert.info/2010/07/email-when-ownership-is-assigned-item-level-permissions/) Notification works fine otherwise, so their's no email issues etc. Can anyone explain to me why this does not work? Cheers, Phil.

Strange notification emails from workflow tasks

Pardon if this is a dumb question, but I can't figure it out. I am setting up a purchase request workflow and it works, but for some reason extra emails are being created and sent to a different address. I didn't put this address into the workflow so I am unsure why it is doing it.   My work flow consists of a simple start approval process to a set email address. Then an if and else to send emails (hardcoded) based on the approval status. The email address is mine and I don't have any diversions on it. An example of the emails: ---------------------------------------------- Approval has completed on 4444444. Approval on 4444444 has successfully completed. All participants have completed their tasks.   Approval started by ######\intranet on 9/16/2010 12:45 PM Comment: Rejected by ########P\intranet on 9/16/2010 12:48 PM Comment:  ---------------------------------------- I only have myself in the approving group. And I have gone through all my settings (well I think I have) and I can't find where this email address or setting is. Thanks in advance. Again, sorry if this is a dumb question.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend