.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

How to do Time bound workflow execution

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :WPF
The requirement is that the workflow should complete in a time specified as a workflow parameter, if it is not able to execute all the activities , it should terminate itself. Can anybody give me an idea how i can do that. regards

View Complete Post

More Related Resource Links

How to keep my Workflow alive only during the time my client application is running ?

Hi, I want to my workflow do some action when server  lose connection with client and at the same time client get exceptions about it. It is possible to implement some session mechanism or something like that with workflow service ? Regards Marcin

improve sql execution time

i need to select one of the record out of 10 thourands record,but when the program execute the sql , it takes a long time to extract data and my PC indicate low memory alert.   how can i improve the execution time to select the data from sybase

Automatic Workflow execution

Hi folks, I have a task list which i have set to (require content approval for submitted items). I want to move the tasks which are APPROVED to another approved list. To accomplish it, i created a workflow in SPD. if Current Item:Approval Status equals 0;#Approved                 Email Current Item:Assigned To                 then Copy item in Current Item to Approved Tasks                 then Delete item in Current Item   I have set the workflow to automatically start when a new item is created or changed. When i approve a task; the workflow does not start. I have to manually start the workflow which then works fine as designed. Please advise what is missing for the automatic worklflow execution to work.You miss 100% of the shots you do not take!

Get Query execution time

I need to find out the query execution time from the front end .Where should I insert the code for that.Please help.. I am using the bleow query: OracleConnection con = new OracleConnection(ConnStr); con.Open();  OracleCommand cmd = new OracleCommand("Stored_Proc",con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(); .................... ................ OracleDataAdapter oda = new OracleDataAdapter (cmd);  

how to send an email using sharepoint designer workflow when an item equals to end time

hi, How to trigger the workflow when current time is equl to end time. I need to send an document when  current time is equl to end time. I am using designer workflows(sharepoint 2007).I have created a variable and i am able to get todays date but not able to get time by default i am getting 12:00:00 Am.i want to get current time. can u please tell me.

Disable an activity in Designer at run time in workflow 4.0

There are couple of activities in my workflow & based on some condition, I need to make an activity disabled i.e. I don't want that activity to be seletable by the user. I am opening my workflow in designer at run time to give an overview of WF to the user. Something like  (new DesignerMetadata()).Register(); this.wd = new System.Activities.Presentation.WorkflowDesigner(); this.designerSection.Child = (this.wd.View); I was going thru the MS sample of CommentOut Activity but that won't solve my requirement as Activity needs to be disabled at run time based on some condition.

rules execution without workflow and ruleengine

Hi,   I have a XML file with rules. If I execute that XML file using Rule Engine, it is taking lot of time. So I wonder, Can i execute the XML file with C#? convert that file to regular C# code in runtime? and execute it without RuleEngine. Is there any possibility?

sharing data between workflow during execution

Hello, I have number of workflows which are running at the sametime. I have a activity that gets the file from a remote location. It is possible that multiple workflow might require the same file. Is it possible, that once a given workflow has requested for the file, and if someother workflow wants the same, instead of looking for file, it waits for it, when the other workflow has downloaded the file, then it can use the same file. Similarly i have workflow loading files to a dataset, it is possible that other activity might want to load the same to a dataset can somebody please point to me, how can i do it, i have read about extension, but I am not able to find any documention, thats shows how can i use them for sharing information between workflows.

rules execution without workflow and ruleengine

Hi,   I have a XML file with rules. If I execute that XML file using Rule Engine, it is taking lot of time. So I wonder, Can i execute the XML file with C#? convert that file to regular C# code in runtime? and execute it without RuleEngine. Is there any possibility?

Execution Time changes in a fashion


Hi All,

Here is my problem,

I have an sp to retrieve max 1000 records(from joining 6 diff tables & conditions too). 

suddenly a bulk amount (millions)of records inserted to the tables.

Here is the statistics of the sp executed in an order :[any way result will be top 1000]

0 seconds for querying a dept of 10500 records without extra parameters.

0 seconds for querying a dept of 10500 records with extra parameters.

4 seconds for querying a dept of 700500 records without extra parameters.

8 seconds for querying a dept of 700500 records with extra parameters.

now the problem starts

3 minutes for querying a dept of 700500 records without extra parameters.[which previously executed in 4 seconds.]

Thanks for looking into this,

Any solution/suggestion will help me to recover from mental stress :(


Query execution time from 1 second in SQL 2000 to 20 Seconds in SQL 2008 R2


When I ran this query from SQL 2000 it takes 1 second. now in SQL 2008 R2  the same query is 20 times slower.

This is the query and the numer of records and the time in SQL 2008 R2:

SELECT * FROM dbo.CxP_Saldos 
0 seconds, 923 Rows
SELECT * FROM S_Conta.Cuentas
0 seconds, 662 Rows
SELECT * FROM S_Conta.Cuentas c INNER JOIN dbo.CxP_Saldos s ON c.id = s.CtaProv
18 seconds, 923 Rows

how can I submit the actual execution Plan?

Report Execution Time Out/Delayed


I have a report i have developed in Bids sourcing from AS cube. Whe I execute the report inside BIDS, i get the results within couple of seconds. But when i run the same report from Report Manager Site, It process for a long time and then generate the following error. Any ideas gues?

An error occurred during client rendering. An error has occurred during report processing. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


Time card management template workflow issue


If we installed Time card management template in share point 2007 By default it will be working (work flow) right?

Otherwise we have to configure anything?

If i try this workflow message is failed to start

Nested Views execution time, how long does it take to "unpack" the SQL?


We have the case where in a reporting solution for an application it was decided to build a series of reporting views, fair enough. These views are layered, nested several levels deep at times and, not unexpectedly, as our customer's data grows so these views slow...

To complicate matters further, the report SQL may then join several of these top level reporting views to produce the data it needs.

In a recent support request for a slow performing report we ripped the sql out of the report, pasted it into SSMS and while investigating found a join error in the reports SQL that took execution time from ~ 2 minutes down to about 6 seconds...  Regardless of what we did after that we were unable to reduce the time below 6 seconds using our reporting views. Rewriting the SQL against our base tables takes a fraction of a second to return the needed information.

What I need to do is demonstrate where the extra time in getting the results from the views is spent.  My guess is that it is in untangling all the views and then ending up with a less than optimal query plan. Is there anyway to measure how long it takes the server to "unpack" the nested views into a single SQL statement before it can be executed? Knowing how much of the 6 seconds this is accounting for would be helpful to us in our decision making process.



Workflow or Time Job for email reminder on Tasks List in Share Point 2007


I need to send a reminder to the person whom a task has been assigned 3 days before a due date. We also wants to re-use this workflow/time job on other lists as well. Name of the lists can be different??


Also if the due date gets change it should change the reminder accordingly.

Which approach i should take to achieve this?? 




Workflow SPD: Set Today Date+Time to Column-field




I have a little question about settings specific today (Date + Time) value to a field/column within a workflow that is designed by Sharepoint Designer 2007.


I can manage to set the field to today() => but the time is always 00:00 houres.

I would like to set a specific field to the "exact" date+time when the workflow is running. (so choosing a fixed date+fixed Time isn't a solution either)


So I anyone could help me how I can do such "simple" task, I would be very pleased.






Decrease Query execution time

Hello friends,
I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc.
I want to decrease it and want to make it execte withing 30-40 sec..
It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons.
so any ideas....
Confused D'Oh! 
One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table.
if its possible then how can i do it?Is there any other way to solve this problem?

Thanks in advance.. Smile 

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