The SQL Server agent checks whether the job is already running before starting a new iteration. If you have long running job and its schedule comes up, it would be skipped until the next interval.

You can try this for yourself. If you try to start a job that&#39;s already running, you will get an error to that effect.

I&#39;m pretty sure it will skip it if it is running.

Which version of SQL Server are you using? This seems like a pretty easy thing to test. Set up a job with a WAITFOR in it that inserts a single row into a table and set up the job to run twice in quick succession (shorter than the WAITFOR DELAY).

When running such a test in SQL Server 2005 it skipped the run that was overlapped.

I have a master branch in my project, that I use to pull changes from other people. From that, I usually have several topic branches on which I&#39;m currently working.

My question is: Is there a way for me to pull new changes into my master and then rebase ALL of my topic branches onto that at once?

This is the situation:

            D--E topic1
           /
    A--B--C master
           \
            F--G topic2

And I want to accomplish this with one single command (H came from upstream) :

&lt;pre&gt;
               D&#39;--E&#39; topic1
              /
    A--B--C--H master
              \
               F&#39;--G&#39; topic2
&lt;/pre&gt;

Now, I know I can accomplish this by rebasing topic1 and topic2 onto master, and I could even write a script to automate this. But what if I have several other branches, create new ones and delete others frequently and I receive upstream changes all the time?

This operation (several rebases), when done by hand, is both tiring and error-prone.

Is there an easier way?

How to rebase many branches (with the same base commit) at once?

XML: `/A/B` or `/A`

I want to get all `A` nodes that do not have any `B` children.

I&#39;ve tried 

    /A[not(B)]  
    /A[not(exists(B))]

without success

I prefer a solution with the syntax `/*[local-name()=&quot;A&quot; and .... ]`, if possible. Any ideas that works?

Clarification. The xml looks like:

    &lt;WhatEver&gt;
      &lt;A&gt;
        &lt;B&gt;&lt;/B&gt;
      &lt;/A&gt;
    &lt;/WhatEver&gt; 

or

    &lt;WhatEver&gt;
      &lt;A&gt;&lt;/A&gt;
    &lt;/WhatEver&gt;




XPath - Get node with no child of specific type

If you schedule a SQL Server job to run every X number of minutes, and it does not finish the previous call before the # of minutes is up, will it skip the run since it is already running, or will it run two instances of the job doing the same steps?

Will a SQL Server Job skip a scheduled run if it is already running?

<p>If you schedule a SQL Server job to run every X number of minutes, and it does not finish the previous call before the # of minutes is up, will it skip the run since it is already running, or will it run two instances of the job doing the same steps?</p>


I have a situation where i need to enforce a unique constraint on a set of columns, but only for one value of a column.

So for example I have a table like Table(ID, Name, RecordStatus).

RecordStatus can only have a value 1 or 2 (active or deleted), and I want to create a unique constraint on (ID, RecordStatus) only when RecordStatus = 1, since I don&#39;t care if there are multiple deleted records with the same ID.

Apart from writing triggers, can I do that?

I am using SQL Server 2005.

conditional unique constraint

I have a simple SQL query in PostgreSQL 8.3 that grabs a bunch of comments. I provide a *sorted* list of values to the `IN` construct in the `WHERE` clause:

    SELECT * FROM comments WHERE (comments.id IN (1,3,2,4));

This returns comments in an arbitrary order which in my happens to be ids like `1,2,3,4`.

I want the resulting rows sorted like the list in the `IN` construct: `(1,3,2,4)`.  
How to achieve that?

ORDER BY the IN value list

I&#39;m not talking about doing a &quot;SET NOCOUNT OFF&quot;.  But I have a stored procedure which I use to insert some data into some tables.  This procedure creates a xml response string, well let me give you an example:

    CREATE PROCEDURE [dbo].[insertSomeData] (@myParam int) AS
    DECLARE @reply varchar(2048)
    
    ... Do a bunch of inserts/updates...

    SET @reply = &#39;&lt;xml&gt;&lt;big /&gt;&lt;outputs /&gt;&lt;/xml&gt;&#39;
    SELECT @reply
    GO

So I put together a script which uses this SP a bunch of times, and the xml &quot;output&quot; is getting to be too much (it&#39;s crashed my box once already).  

Is there a way to suppress or redirect the output generated from this stored procedure?  I don&#39;t think that modifying this stored procedure is an option.

thanks.


----------

I guess i should clarify.  This SP above is being called by a T-SQL Update script that i wrote, to be run through enterprise studio manager, etc.

And it&#39;s not the most elegant SQL i&#39;ve ever written either (some psuedo-sql):

    WHILE unprocessedRecordsLeft
      BEGIN
        SELECT top 1 record from updateTable where Processed = 0
        EXEC insertSomeData @param = record_From_UpdateTable
      END

So lets say the UpdateTable has some 50k records in it.  That SP gets called 50k times, writing 50k xml strings to the output window.  It didn&#39;t bring the sql server to a stop, just my client app (sql server management studio).



How to Suppress the SELECT Output of a Stored Procedure called from another Stored Procedure in SQL Server?

It is safe to say that the [EAV/CR][1] database model is bad.  That said, 

Question: **What database model, technique, or pattern should be used to deal with &quot;classes&quot; of attributes describing e-commerce products which can be changed at run time?**  

In a good E-commerce database, you will store classes of options (like TV resolution then have a resolution for each TV, but the next product may not be a TV and not have &quot;TV resolution&quot;).  How do you store them, search efficiently, and allow your users to setup product types with variable fields describing their products?  If the search engine finds that customers typically search for TVs based on console depth, you could add console depth to your fields, then add a single depth for each tv product type at run time.

There is a nice common feature among good e-commerce apps where they show a set of products, then have &quot;drill down&quot; side menus where you can see &quot;TV Resolution&quot; as a header, and the top five most common TV Resolutions for the found set.  You click one and it only shows TVs of that resolution, allowing you to further drill down by selecting other categories on the side menu.  These options would be the dynamic product attributes added at run time.

**Further discussion:**

So long story short, **are there any links out on the Internet or model descriptions that could &quot;academically&quot; fix the following setup?**  I thank Noel Kennedy for suggesting a category table, but the need may be greater than that.  I describe it a different way below, trying to highlight the significance.  I may need a viewpoint correction to solve the problem, or I may need to go deeper in to the EAV/CR.

Love the positive response to the EAV/CR model.  My fellow developers all say what Jeffrey Kemp touched on below: &quot;new entities must be modeled and designed by a professional&quot; (taken out of context, read his response below).  The problem is:

 - entities add and remove attributes weekly &lt;br /&gt; *(search keywords dictate future attributes)*
 - new entities arrive weekly &lt;br /&gt; *(products are assembled from parts)*
 - old entities go away weekly &lt;br /&gt; *(archived, less popular, seasonal)*

The customer wants to add attributes to the products for two reasons:

 - department / keyword search / comparison chart between like products
 - consumer product configuration before checkout

The attributes must have significance, not just a keyword search.  If they want to compare all cakes that have a &quot;whipped cream frosting&quot;, they can click cakes, click birthday theme, click whipped cream frosting, then check all cakes that are interesting knowing they all have whipped cream frosting.  This is not specific to cakes, just an example.

  [1]: http://en.wikipedia.org/wiki/Entity-attribute-value_model

Entity Attribute Value Database vs. strict Relational Model Ecommerce

&gt; **Duplicate of**  
[Dynamic SQL Comma Delimited Value Query][1]  
[Parameterized Queries with Like and In][2] 

I have a SQL Server Stored Procedure where I would like to pass a `varchar` full of comma delimited values to an `IN` function. For example:

    DECLARE @Ids varchar(50);
    SET @Ids = &#39;1,2,3,5,4,6,7,98,234&#39;;
    
    SELECT * 
    FROM sometable 
    WHERE tableid IN (@Ids);

This does not work of course. I get the error:

&gt; Conversion failed when converting the varchar value &#39;1,2,3,5,4,6,7,98,234&#39; to data type int.

How can I accomplish this (or something relatively similar) without resorting to building dynamic SQL?

  [1]: https://stackoverflow.com/questions/517028/dynamic-sql-comma-delimited-value-query
  [2]: https://stackoverflow.com/questions/303149/parameterized-queries-with-like-and-in-conditions

Passing a varchar full of comma delimited values to a SQL Server IN function

I need a SQL query to find the names of existing databases.

SQL Server query to find all current database names

Can you create an index on a table variable in SQL Server 2000?

i.e. 

    DECLARE @TEMPTABLE TABLE (
         [ID] [int] NOT NULL PRIMARY KEY
        ,[Name] [nvarchar] (255) COLLATE DATABASE_DEFAULT NULL 
    )

Can I create an index on `Name`?






Creating an index on a table variable

I have a webpage hosted on a Windows box that I need to assure gets loaded at least once/day. My current plan is to create a scheduled task that opens Internet Explorer and hits the URL:

    &quot;C:\Program Files\Internet Explorer\iexplore.exe&quot; myurl.com/script_to_run_daily.aspx

This was simple to setup and works fine, but it strikes me as a hack because Internet Explorer actually has to open and hit this URL. I don&#39;t need any input back from this page, it simply stores cached data in files when it&#39;s hit.

Is there a slicker way of doing this? In case it matters, this is a VB.net site.

Thanks in advance!

Recommended method for loading a URL via a scheduled task on Windows

I&#39;m trying to schedule a repeating event to run every minute in Python 3.

I&#39;ve seen class `sched.scheduler` but I&#39;m wondering if there&#39;s another way to do it. I&#39;ve heard mentions I could use multiple threads for this, which I wouldn&#39;t mind doing.

I&#39;m basically requesting some JSON and then parsing it; its value changes over time.

To use `sched.scheduler` I have to create a loop to request it to schedule the even to run for one hour:

    scheduler = sched.scheduler(time.time, time.sleep)
    
    # Schedule the event. THIS IS UGLY!
    for i in range(60):
        scheduler.enter(3600 * i, 1, query_rate_limit, ())
        
    scheduler.run()

What other ways to do this are there?

Schedule a repeating event in Python 3

I have seen references online that state that &#39;Scheduled Tasks&#39; in Windows are stored in `%SystemRoot%\Tasks`, which I think usually equates to `C:\Windows\Tasks`.

However, I observe that while that folder exists on my Windows 7 system, Scheduled tasks doesn&#39;t use it. 

My system appears to use, `C:\Windows\System32\Tasks`.

I have studied the Environment variables and there doesn&#39;t seem to be anything related to `Scheduled Tasks` there.

How do I discover which folder is used for Scheduled tasks?

How to find the location of the Scheduled Tasks folder

I&#39;ve searched on SO and found answers about Quartz.net. But it seems to be too big for my project. I want an equivalent solution, but simpler and (at best) in-code (no external library required). How can I call a method daily, at a specific time? 

I need to add some information about this:

- the simplest (and ugly) way to do this, is check the time every second/minute and call the method, at right time

I want a more-effective way to do this, no need to check the time constantly, and I have control about whether the job is done a not. If the method fails (because of any problems), the program should know to write to log/send a email. That&#39;s why I need to call a method, not schedule a job.

I found this solution https://stackoverflow.com/questions/2331736/call-a-method-at-fixed-time-in-java in Java. Is there a similar way in C#?

EDIT: I&#39;ve done this. I added a parameter into void Main(), and created a bat (scheduled by Windows Task Scheduler) to run the program with this parameter. The program runs, does the job, and then exits. If a job fails, it&#39;s capable of writing log and sending email. This approach fits my requirements well :)


How to call a method daily, at specific time, in C#?

I want to write a batch file that performs the following operations: 
 
 * Check if a service is running  
  * If is it running, quit the batch  
  * If it is not running, start the service  

The code samples I googled so far turned out not to be working, so I decided not to post them. 

Starting a service is done by:

    net start &quot;SERVICENAME&quot;

1. How can I check if a service is running, and how to make an if statement in a batchfile?  
2. I&#39;m a bit confused. What is the argument I have to pass onto the net start? The service name or its display name?

Content Type	Original Author	Original Content on Stackoverflow
Question	Sam Schutte	View Question on Stackoverflow
Solution 1 - Sql	Jose Basilio	View Answer on Stackoverflow
Solution 2 - Sql	PQW	View Answer on Stackoverflow
Solution 3 - Sql	Tom H	View Answer on Stackoverflow

Will a SQL Server Job skip a scheduled run if it is already running?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

XPath - Get node with no child of specific type

How to rebase many branches (with the same base commit) at once?

Attributions