Results 1 to 3 of 3

Thread: Trigger Help

  1. 11-18-2002, 06:40 AM #1
    rahuularya
    rahuularya is offline Registered User
    Join Date
    Nov 2002
    Posts
    7

    Trigger Help

    Hi all,

    Can anyone tell me as how can i execute a trigger on some particular date.
    Say for example, I want a trigger to fire on 1st January every year, so that my tables for leave etc. get filled automatically.

    Thanks in Advance
    Rahul
    Reply With Quote Reply With Quote
  2. 11-18-2002, 09:51 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Trigger fires only when data in the table modified. You may try scheduled job for that.
    Reply With Quote Reply With Quote
  3. 11-18-2002, 11:47 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    u need to create a job for this and schedule it for monthly for every 12 months.
    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