Triggers in SQL SERVER
Hai everybody,
this is my first query to this datacenter. pblm is i need
to write a trigger in sql server which should fire
automatically everyday at a particular time say 9.30 am.
once again iam remainding its to be written in sql server.
also whts the equivalent operation of logon event and
atartup/shutdown event of oracle to sql server.
hoping the reply as soon as poosible
thankingyou
rm manickam
Software/Hardware used:
Software/Hardware used:
ASKED:
November 9, 2005 12:32 AM
UPDATED:
November 9, 2005 1:30 PM
Answer Wiki:
Triggers are executed when an action (INSERT, UPDATE or DELETE) occurs on a table row. You can't schedule a job to execute a trigger...you can only schedule a job to execute a T-SQL statement that in turn fires the trigger. So what you need to do is create a job that either runs a T-SQL statement or stored procedure that executes the operation you wish to perform.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
