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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

RE:Sql task for automation..............

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
 
Hi All,          I have a Table1 with say 3 cols. which has datetime as 1 col.I want to get the difference of rows for 2 diff dates as the condition for the same table.And want to compare the difference value against a fixed value say o.3.so this is sumthing like..... table1 (col1---col2--datetime1) - table1 (col1---col2--datetime2)= difference value; if difference value>0.3 send an email alert else ignore this has to happen on the daily basis....automated..... can any 1 pls help me out how can i achieve this.... i was wondering to write a winform appl and schedule the task on daily basis or can i do it from the sql serve itself instead of doing it with .net/winforms.   pls help me ....Thanks a million for ideas.....!!!!!!!!!!! table1 


View Complete Post


More Related Resource Links

SQL Server and DMO: Distributed Management Objects Enable Easy Task Automation

  

SQL Server can be administered programmatically using system stored procedures, but Distributed Management Objects (DMO) offer a more modern, object-oriented alternative. This article introduces SQL-DMO in SQL Server 7.0 and SQL Server 2000 and describes the SQL-DMO object model, then focuses primarily on the Databases tree and the JobServer tree of the object model. The sample code and the article show how to use various objects such as the Registry object, the Configuration object, and the Database object to automate common administration tasks such as programmatically retrieving configuration settings, creating new databases, applying T-SQL scripts, and creating and scheduling backups.

Francesco Balena

MSDN Magazine May 2001


Excel Automation in .Net

  
Excel Automation is a buzz word in both webapps and winapps. In the programming life (like Mr.Anderson neo) I guess almost every one could have come across this word. For others let me go further in detail. Excel Automation is automating some or all of the process involved in creating or updating excel worsheets.

How to run Office macros by using Automation from Visual Basic .NET

  
This step-by-step article describes how to call Office macros from a Visual Basic .NET Automation client.

You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and execute the macro at run time.

Word Automation Issue in Windows Server 2008 Hosting

  

Hi,

The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.


With Regards,

Ashok



Word Automation - Multiple DCOM Errors/Behavior

  
Before I get started, I already know that Microsoft does not support and highly discourages server-based MS Office automation.  I've read a multitude of posts and smarmy "*wink*, here's a link" replies, so I'm looking for actual help here, not condescending reprimands.

That notwithstanding, here is my problem.  I have developed a simple method that will open a local Word document, modify some header information, and then save the document as a new file.  As expected, it works great as a console/windows app, but as soon as I went to ASP.NET, DCOM jacked my world up when accessing the app remotely from a different domain account (that has access to the ASP.NET app.  For reference, my method is shown below:

  

1    public static string ModifyAndSaveBuildDocument(string localFilePath, BuildDocumentType docType, string buildNumber, DateTime buildDate, string projectName)
2            {
3                try
4                {
5                    ProjectConfiguration config = (ProjectConfiguration)ConfigurationManager.GetSection("ProjectConfiguration");
6    

Test Run: Web Application HTTP Request-Response Test Automation with JavaScript

  

Write a simple browser-based request-response test automation using JavaScript that's platform independent and useful when you are working in a highly dynamic environment.

James McCaffrey

MSDN Magazine January 2010


Parallel Debugging: Debugging Task-Based Parallel Applications in Visual Studio 2010

  

In Visual C++ 10 and the Microsoft .NET Framework 4, Microsoft is introducing new libraries and runtimes to significantly ease the process of expressing parallelism in your code base, together with new tool support for performance analysis and debugging of parallel applications. In this article, you will learn about debugging support in Visual Studio 2010, much of which is focused on task-based programming models.

Stephen Toub, Daniel Moth

MSDN Magazine September 2009


Test Run: Web UI Automation with Windows PowerShell

  

Here we show you how to use Windows PowerShell to create quick and easy UI test automation for ASP.NET and classic ASP Web applications.

Dr. James McCaffrey

MSDN Magazine March 2008


Test Run: Custom Test Automation with Team System

  

In this month's column Dr. James McCaffrey describes some of the ways you can use the Visual Studio 2005 Team System to manage custom software test automation.

Dr. James McCaffrey

MSDN Magazine Launch 2008


Test Run: The Microsoft UI Automation Library

  

James McCaffrey shows you how to get started with UI test automation using the new Microsoft UI Automation library.

Dr. James McCaffrey

MSDN Magazine February 2008


Test Run: UI Automation with Windows PowerShell

  

This installment of Test Run is a guide to using Windows PowerShell to perform ultra lightweight UI automation.

Dr. James McCaffrey

MSDN Magazine December 2007


Test Run: Test automation with Windows XP Embedded

  

This month's column explores how to create lightweight but powerful UI test automation for software systems that run on Windows XP Embedded.

Dr. James McCaffrey and Mike Hall

MSDN Magazine October 2007


Windows with C++: Task Scheduler 2.0

  

The new Task Scheduler in Windows Vista can do so much more than previous versions. We introduce some basic concepts and building blocks you can put to use in your own scheduled task projects.

Kenny Kerr

MSDN Magazine October 2007


Test Run: AJAX Test Automation

  

This month James McCaffrey presents a technique that allows you to write lightweight test automation to verify the functionality of AJAX Web applications.

Dr. James McCaffrey

MSDN Magazine February 2007


Cutting Edge: Simplify Task Progress with ASP.NET "Atlas"

  

Dino Esposito rewrites his task progress bar with the help of ASP.NET "Atlas."

Dino Esposito

MSDN Magazine October 2006


Cutting Edge: Reporting Task Progress With ASP.NET 2.0

  

The progress bar is great for keeping users informed about the progress of a task. Unfortunately, there's no progress bar element built into ASP.NET, so Dino Esposito solves that problem with his ProgressPanel control.

Dino Esposito

MSDN Magazine September 2006


Categories: 
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