Triggers in SQL SERVER

pts.
Tags:
Desktops
Management
Microsoft Windows
OS
Security
Servers
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following