trigger problem
-
how to trigger fire on speceific date,days or time
-
Does sound like you need a trigger, but a scheduled job to accomplish a specifc task or set of tasks. Triggers are fired on a table in response to an INSERT, UPDATE, or DELETE action occuring on the target table.
-
Create a one-column table.
Create a stored procedure that updates that single row.
Create an update trigger for the table to do what you want.
Create a job that runs the stored procedure mentioned above.
DONE!
Mike Harris
Data Modeling & Administration
Charlotte, NC -
Just create a job that does what you want and schedule it to run when you need it.
No need for all the rest.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply