473,602 Members | 2,887 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

scheduled job

Just rand across this article:

http://www.aspfaq.com/show.asp?id=2143, which led to this article on using a
SQL Server job: http://www.aspfaq.com/show.asp?id=2403

Here's my question: I have an intranet app which tracks tickets for tech
support. The boss wants it so that, depending on the severity of the ticket,
we go into the DB and check every 15 minutes or so to see if the ticket is
being handled. If no activity is detected in an accepted amount of time,
then an email gets sent automatically to certain managers,

The first article cited above gives 4 options, and the last two aren't
possibilities in my case. I'm leaning toward option 2, which is the SQL
job, but will take advice.

Anyone here know of a better solution?

I should add that stored procedures are not an option. Long story.
Jul 19 '05 #1
12 2198
Stored procedures aren't an option but scheduling jobs is? That's odd.

I'd go with the SQL solution, personally. Either that, or I'd just buy
www.helpstar.com and be done with it. It's one of the few non-MS
applications that I don't bitch about every single time I use it. It's not
bad, and it has served my department well for many years. But, I regret to
say that we're dropping it in favor of an AS/400 based solution.

Ray at work

"middletree " <mi********@hto mail.com> wrote in message
news:eo******** ******@TK2MSFTN GP10.phx.gbl...
Just rand across this article:

http://www.aspfaq.com/show.asp?id=2143, which led to this article on using a SQL Server job: http://www.aspfaq.com/show.asp?id=2403

Here's my question: I have an intranet app which tracks tickets for tech
support. The boss wants it so that, depending on the severity of the ticket, we go into the DB and check every 15 minutes or so to see if the ticket is
being handled. If no activity is detected in an accepted amount of time,
then an email gets sent automatically to certain managers,

The first article cited above gives 4 options, and the last two aren't
possibilities in my case. I'm leaning toward option 2, which is the SQL
job, but will take advice.

Anyone here know of a better solution?

I should add that stored procedures are not an option. Long story.

Jul 19 '05 #2
> Anyone here know of a better solution?

That kind of depends on why some of the solutions are not options, doesn't
it?
I should add that stored procedures are not an option. Long story.


Oh, please expand. I love to hear the excuses for using ad hoc SQL. And
show anyone who is forbidding stored procedures, this article:
http://www.aspfaq.com/2201
Jul 19 '05 #3

"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:e5******** ******@TK2MSFTN GP10.phx.gbl...
Anyone here know of a better solution?


That kind of depends on why some of the solutions are not options, doesn't
it?


Option 3 starts with, "If it's a high-traffic site", and this app does not
fit that IF condition.
Option 4 is to have the web page open 24/7 using META refresh. Um, do I
need to explain why this isn't gonna happen?

I should add that stored procedures are not an option. Long story.


Oh, please expand. I love to hear the excuses for using ad hoc SQL. And
show anyone who is forbidding stored procedures, this article:
http://www.aspfaq.com/2201


I offer no excuses. I can't use SP, period. I have tried to convince the
owner of the database, but he ain't budging. It's his Intranet, and my
ticket tracking app simply does a piggy-back onto that. I need to use his
database because customer and employee info is already in there, and no
point in having it in two places, so I work around his rules. Even if I
wanted to create my won DB, my boss has already decreed that I use the
existing intranet one. He's the boss. I got kids to feed. I do what I'm
told.

So I have some permissions on the DB, but not a lot. If I need to create a
new field, for example, I have to email the guy who owns it, and he gets it
done in a day or two. Can't do anything about it.

Now, having established that, I was going to write an ASP page which would
check these things, then send the emails as needed, and then have some other
program, maybe a custom-built exe, which would call this ASP file every 15
minutes. Then I read the article, and thought, maybe this VBScript thing
woudl be better, or maybe a SQL job would be better (If I can talk the
Intranet guy into it).
Jul 19 '05 #4

"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:e7******** ******@TK2MSFTN GP10.phx.gbl...
Stored procedures aren't an option but scheduling jobs is? That's odd.
Read my answer to Aaron. Yes, it's odd, but it's what I'm working with.
Beats being unemployed.

And no, there's no guarantee that I will get approval to get the job thing
going. Just wnated input from you guys before I went to ask.

I'd go with the SQL solution, personally. Either that, or I'd just buy
www.helpstar.com and be done with it.


I don't have the option of spending money.
Jul 19 '05 #5

"middletree " <mi********@hto mail.com> wrote in message
news:ei******** ******@TK2MSFTN GP10.phx.gbl...

Now, having established that, I was going to write an ASP page which would
check these things, then send the emails as needed, and then have some other program, maybe a custom-built exe, which would call this ASP file every 15
minutes. Then I read the article, and thought, maybe this VBScript thing
woudl be better, or maybe a SQL job would be better (If I can talk the
Intranet guy into it).


Now knowing your server dilemma, I'd go with a dedicated task machine.
There were a bunch of various tasks that I had running on different
machines, and it became a bit of a mess. So, I took an old Compaq EVO that
was laying around set it up as a task "server." It runs all my scheduled
tasks for me. No one else touches the machine, and it just sits on my desk
with some other computers. I don't back it up or anything. I just document
the task schedules and keep backup copies of the .bats, .exes, .vbss, etc.
on a server that is backed up. So, I would go with the .vbs solution on
another machine that you control, if that is an option.

Ray at work
Jul 19 '05 #6
> I don't have the option of spending money.

I know it's not exactly a seller's market, but surely these people must
realize that they're making it almost impossible for you to get anything
done? Wait one or two days for someone to add a column to a table? Be
forbidden from using stored procedures, or creating your own replicated
database? Spend valuable engineering time applying learning curves to a
home remedy, instead of buying a relatively cheap off-the-shelf solution?

Ugh, I'd be shopping around.
Jul 19 '05 #7
> I offer no excuses. I can't use SP, period. I have tried to convince the
owner of the database, but he ain't budging. It's his Intranet, and my
ticket tracking app simply does a piggy-back onto that. I need to use his
database because customer and employee info is already in there, and no
point in having it in two places, so I work around his rules. Even if I
wanted to create my won DB, my boss has already decreed that I use the
existing intranet one. He's the boss. I got kids to feed. I do what I'm
told.

So I have some permissions on the DB, but not a lot. If I need to create a
new field, for example, I have to email the guy who owns it, and he gets it done in a day or two.


If anybody saw 24 last night, this guy totally reminds me of that jerk who
freaked out because Claudia touched his file system.

A
Jul 19 '05 #8

"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:uC******** ********@TK2MSF TNGP12.phx.gbl. ..
If anybody saw 24 last night, this guy totally reminds me of that jerk who
freaked out because Claudia touched his file system.


Last night was opening night for the NBA. Come on now.

Ray at work
Jul 19 '05 #9
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:uC******** ********@TK2MSF TNGP12.phx.gbl. ..
I offer no excuses. I can't use SP, period. I have tried to convince the
owner of the database, but he ain't budging. It's his Intranet, and my
ticket tracking app simply does a piggy-back onto that. I need to use his database because customer and employee info is already in there, and no
point in having it in two places, so I work around his rules. Even if I
wanted to create my won DB, my boss has already decreed that I use the
existing intranet one. He's the boss. I got kids to feed. I do what I'm
told.

So I have some permissions on the DB, but not a lot. If I need to create a new field, for example, I have to email the guy who owns it, and he gets

it
done in a day or two.


If anybody saw 24 last night, this guy totally reminds me of that jerk who
freaked out because Claudia touched his file system.


LOL!

24 Rules! :)

-Peter
Jul 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
4763
by: Bart Simpson | last post by:
Hi, I want to control 'Scheduled Tasks' in Windows 2003 by python program. But I couldn't find any Python module about win32 'Scheduled Tasks'. I could find only Perl module about it. (see http://taskscheduler.sourceforge.net) But, I want to control 'Scheduled Tasks' by python :) Is there any python module about win32 'Scheduled Tasks'?
4
14687
by: Colin Steadman | last post by:
We have a number of scheduled tasks on our IIS server that run daily at some point during the early morning. These tasks run as a specific user that has the correct permissions to perform whatever task (processing SQL so I'm told) I have been asked if I can setup a page within ASP that a user could logon to with their own credentials (this I can do). And once logged on be presented with a list of scheduled tasks which they can then...
5
4568
by: A. Lovhaug | last post by:
I have a console application built in the .NET Framework. This application basically executes an XCopy based on parameters that I pass to it. I use it for creating scripts for backing up folders, etc. All my command scripts utilizing this console application work fine when they are executed interactively. However, if they are executed via a scheduled task, they do not run. Or more precisely, the script seems to execute at the...
6
8231
by: John Bowman | last post by:
Hi, I have a C# app that needs to launch the "Add Scheduled Tasks" wizard found in the control panel "Scheduled Tasks" applet. I realize that this "applet" really just opens the tasks folder, but I need to launch the add tasks wizard inside the folder. Does anyone have any ideas of how to do this? I can't find anything in the MSDN regarding this. All it mentions is the Task Scheduler API and I can't seem to find it in there either. Did...
3
22947
by: Lenn | last post by:
Hi, I developed a console .exe application which is going to run on scheduled basis, it will be scheduled to run in Windows Scheduled tasks. Client wants some kind of utility that would help them manage scheduled tasks on different servers. So, how can I add scheduled task to local machine or remote servers programmatically? Thanks.
1
1839
by: satelite | last post by:
Hello, I am writing an exe that is intended to be run via a scheduled task. However, I also need the flexibility to have users run the scheduled task manually (right click task and select run). In the event a user runs the task manually I need to verify their identity for logging purposes. So I have two questions: 1. Is there a way to tell if a scheduled task was run because of its scheduled time or if a user manually initiated it?...
2
3105
by: Tatter | last post by:
I have a simple .NET 1.1 console application, written with Visual Studio .NET 2003, that needs to be run on a Windows XP system as a scheduled task. When run on its own, the program executes with no errors. When run as a scheduled task on a computer with debugging tools installed, it runs with no errors. When run as a scheduled task on a computer with no debugging tools installed, namely the Windows XP system it is supposed to be run on, it...
1
7481
by: Myster Edd | last post by:
I have a strange problem that I think deals with security on SQL 2005. I have a scheduled task that runs on a Windows 2000 machine. It calls a vb script which creates a connection to SQL Server. We migrated a database from SQL 2000 to 2005 which is on a different box. I changed the connection in the vb script to use the new sql server. The original connection to SQL 2000 used the 'sa' account coded into the connection string , which...
0
1971
by: Paulson | last post by:
Dear Freinds I want to make a program that acts as a reminder for the users.I need to open up the Scheduled task wizard programmatically.If you type Tasks in the run command the Tasks folder(ie. Scheduled Taks folder) is opened,but what I want is to open the Add Scheduled Task wizard in it.Is there any run command to do that? Also if I am able to open the Scheduled Task wizard like this is there any way by which I can...
9
3766
by: jdaelhousen | last post by:
I have a bit of a problem I'm hoping someone can shed some light on... I have a VB.Net console application written in VS 2003 that produces a .exe file that now sits on a Windows 2000 server directory. This exe does the following 3 things: 1.) Using the VB Interaction SaveSetting() method, it programmatically updates the system registry under the HKEY_CURRENT_USER\SOFTWARE key and saves a directory location used by a PDF driver (so that...
0
7993
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7921
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8404
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8056
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8270
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
5870
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5440
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
1511
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1256
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.