SQL SERVER TRIGGERS

[sris 426]

Hi all, I need to insert a record in to a table automatically on every day at 12 PM.How can I achive this.Will trigger help me in this regard.If not how can I achive this.Please help me.(I want to perform this action in backend only) Thanks in advance, Srinivas Mateti

[i i i]

You can create a Job , which db are you using ???

Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

[Blikkies]

Triggers execute in response to certain events when INSERT, UPDATE or DELETE

[sris 426]

I will be using both MSSQL and MySQL data bases. Thanks, Srinivas Mateti

[sris 426]

So in this case I cant use triggers..right?

[Lost User]

u hv to write a windows service for this.where u can set the exact time.

Thanks and Regards Sujit Kr. Mandal

[Mycroft Holmes]

MSSQL you can create a stored procedure to do the insert and then schedule a job to execute the procedure when required. MySQL - I don't know. As suggested you could use a windows service to do both inserts.

[i i i]

no need to invent the wheel again Sql server job will do the job

Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

[sris 426]

Thanks for the reply.Here the constraint is I cannot use Windowse services.So, I will schedule a job whichi will fire on each day at specific time.In this job i will call the SP which will insert or update the desired record.I hore in MYSQL ALSO it will works.Right.... Thanks, Srinivas Mateti

[Mycroft Holmes]

If MySQL does not support jobs then you may be able to trick SQL Server into doing the job on MySQL as a remote server or a linked server, nasty but it may be possible.

[sris 426]

Oho..This will create more problem for me.I cannot use SQLSERVER to trigger MYSQL.I canot use windowse services.But I need the auto insert action...Is there any other option in MySQl which is similar to MSSQL jobs feature.Please guide me. Thanks in advance, Srinivas Mateti

[David Skelly]

MySQL has an event scheduler which can be used to fire off tasks at specified times or intervals.

[Blikkies]

Correct

[Md Marufuzzaman]

I think you can create a stored procedure for the insertion and call it from a SQL job that's it;

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. Thanks Md. Marufuzzaman