I need to execute one procedure automatically using timers in mssql. for example everyday it will executed automatically at the 12:00 00:00:00:000. Give me some codes for that...
-
-
Don't really need code for that per se. Use the Business Intelligence software (which is a pared down version of Visual Studio) that comes with SQL Server and create an SSIS package. Deploy the package to the server and then set up a job and set the schedule. -
Why not just create a job for it?
Good Luck!!!
~~ CKComment
Comment