Results 1 to 5 of 5

Thread: SQL Server 7 Question...

  1. Apr 29th, 2002, 05:18 AM #1
    Wokawidget
    Wokawidget is offline

    Thread Starter
    Super Moderator Wokawidget's Avatar
    Join Date
    Nov 2001
    Location
    Headingly Occupation: Classified
    Posts
    9,632

    Angry SQL Server 7 Question...

    I have a VB app that uses SQL Server 7.
    The app creates jobs in the Jobs table, the structure is irrelavant for this Q.
    30 days after the job is created it's status is set to cancelled.

    In the Sub Main of my app I can run a procedure which checks all jobs and if any are found that are over 30 days old then the app sets the Cancelled field to TRUE.
    The problem occurs when another app also uses the data in the jobs table. If someone doesn't run the main app then jobs which are greater than 30 days will still be shown as being effective.
    Does SQL Server have an event where I can set it to run at Midnight everyday. This event would run a stored procedure which would automatically cancel jobs...Anyone know if this is possible???
    My .NET Tutorials:
    • Silverlight Enabled WebPart in WSS

    My VB.NET Code Examples:
    • Create IIS Virtual Directory • Validate Login Against Active Directory • Automatically retrieve Identity field value from inserted DataRow using SQL Server and ADO.NET

    My ASP.NET Code Examples:
    • Login To Website (Forms Authentication) • Login To Website (Custom Authentication)

    My VB6 Code Projects:
    • Multithreading In VB6 • Custom Tooltips • Multi Language Support • Item Selector Control • Annimated Systray Icon • Simple Effective Graph Control • Download From Web • LiveUpdate, download application updates from the web automatically • Systray Notification Messages • Skin A Form • API Timer • Badger Messenger, an MSN clone that uses the MSN Network • Wokawidgets VB6 Component Suite
    Reply With Quote Reply With Quote
  2. Apr 29th, 2002, 05:23 AM #2
    GlenW
    GlenW is offline
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479
    Can't you get the 'other App' to do the cancelled thingy as well?
    Reply With Quote Reply With Quote
  3. Apr 29th, 2002, 05:25 AM #3
    Wokawidget
    Wokawidget is offline

    Thread Starter
    Super Moderator Wokawidget's Avatar
    Join Date
    Nov 2001
    Location
    Headingly Occupation: Classified
    Posts
    9,632

    Talking My house is as small as the moon...

    Errr...nope. There are 2 other apps which reference this table, but only one app administers it. Doing an event in SQL Server is far more reliable than copying code from one app to another, then to another...espescially if the functionality changes...
    My .NET Tutorials:
    • Silverlight Enabled WebPart in WSS

    My VB.NET Code Examples:
    • Create IIS Virtual Directory • Validate Login Against Active Directory • Automatically retrieve Identity field value from inserted DataRow using SQL Server and ADO.NET

    My ASP.NET Code Examples:
    • Login To Website (Forms Authentication) • Login To Website (Custom Authentication)

    My VB6 Code Projects:
    • Multithreading In VB6 • Custom Tooltips • Multi Language Support • Item Selector Control • Annimated Systray Icon • Simple Effective Graph Control • Download From Web • LiveUpdate, download application updates from the web automatically • Systray Notification Messages • Skin A Form • API Timer • Badger Messenger, an MSN clone that uses the MSN Network • Wokawidgets VB6 Component Suite
    Reply With Quote Reply With Quote
  4. Apr 29th, 2002, 05:28 AM #4
    Jerry Grant
    Jerry Grant is offline
    Fanatic Member Jerry Grant's Avatar
    Join Date
    Jul 2000
    Location
    Dorset, UK
    Posts
    810
    In SQL Server Enterprise Manager, open the Management tree node for your server, select SQL Server Agent, Jobs.

    In here you can specify scheduled events, like running SPs at specific times...........

    Think this is what you are looking for!
    Jerry Grant................tnarG yrreJ
    Website: <JG-Design></.net>
    Email: [email protected]
    Working towards a bug free world......
    (Not a Microsoft employee)
    Reply With Quote Reply With Quote
  6. Apr 29th, 2002, 05:53 AM #5
    Wokawidget
    Wokawidget is offline

    Thread Starter
    Super Moderator Wokawidget's Avatar
    Join Date
    Nov 2001
    Location
    Headingly Occupation: Classified
    Posts
    9,632

    Talking Spot on Mr Spot....

    Yup, that's exactally what I wanted...

    Cheers.

    I love this web site
    My .NET Tutorials:
    • Silverlight Enabled WebPart in WSS

    My VB.NET Code Examples:
    • Create IIS Virtual Directory • Validate Login Against Active Directory • Automatically retrieve Identity field value from inserted DataRow using SQL Server and ADO.NET

    My ASP.NET Code Examples:
    • Login To Website (Forms Authentication) • Login To Website (Custom Authentication)

    My VB6 Code Projects:
    • Multithreading In VB6 • Custom Tooltips • Multi Language Support • Item Selector Control • Annimated Systray Icon • Simple Effective Graph Control • Download From Web • LiveUpdate, download application updates from the web automatically • Systray Notification Messages • Skin A Form • API Timer • Badger Messenger, an MSN clone that uses the MSN Network • Wokawidgets VB6 Component Suite
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width