RE: Timed Triggers
From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 01/20/05
- Next message: Nigel Rivett: "RE: Track changes made to existing stored procedure"
- Previous message: Muhammad Bilal: "Timed Triggers"
- In reply to: Muhammad Bilal: "Timed Triggers"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 Jan 2005 17:55:02 -0800
Have a look at the agent - you can create a schedule job which can run an sql
script at a specified time each day (for instance).
"Muhammad Bilal" wrote:
> Hi.
> Is it possible to fire a trigger on a specific time i.e. when the system
> time is 1200 hrs(for eg) , trigger fires automatically and run a script
>
> Regards,
> Muhammad Bilal
- Next message: Nigel Rivett: "RE: Track changes made to existing stored procedure"
- Previous message: Muhammad Bilal: "Timed Triggers"
- In reply to: Muhammad Bilal: "Timed Triggers"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
