Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 24th, 2008, 08:31 AM
Authorized User
 
Join Date: Dec 2006
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
Default Scheduling a Job - Filewatcher

I have a job setup which looks for a file in the particular folder for every 20 min. If the particular file is found (say X.txt) it triggers a another job which correspond to the file (Jobname: XXX) and XXX job runs for 45 min. My question here is

1. Will the filewatcher job waits until the XXX job is finish
   (because the filewatcher scheduled to run for every 20 min.)???
   OR the filewatcher job runs for every 20 min though the kicked
   off job is unfinished.

Your help is highly appreciated. Thanks in advance


Thanks,
Chandra
__________________
Thanks,
Chandra
 
Old July 24th, 2008, 11:14 AM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

That depends on several things.

- What kind of application is this? Console, windows service, winforms?
- Is your code multithreaded? If you call job XXX with a blocking call, a file watch event isn't likely to get picked up because the process is blocked and windows messages can't get through.

By your description, it doesn't sound like you are actually using a live file watcher, but rather a scheduled file checker. This will have a different affect as well. If the system that schedules the executions can fire off two instances of the file checker, then you could have simultaneous processes running. You're going to need to provide more information in order for us to guess what will happen.

Wouldn't it be easier to just do some testing? Instead of scheduling for 20 minutes, how about 1. Make a "job" that runs for 1 minute and 30 seconds and see what happens.

-Peter
compiledthoughts.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Scheduling SQL Job through .NET savan_thakkar ASP.NET 1.0 and 1.1 Professional 0 July 18th, 2006 04:28 PM
attach FileWatcher eventhandlers dynamically neethling .NET Framework 1.x 0 January 11th, 2006 10:17 AM
job scheduling wizard vaneza SQL Server 2000 0 August 2nd, 2005 03:17 AM
Problem Scheduling a job on DTS package. pooh2323 SQL Server DTS 2 February 12th, 2004 02:12 PM
Scheduling mrkyn Classic ASP Basics 4 December 1st, 2003 03:11 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.