I want to create a Trigger that will run once a day at a set time.
This trigger would actually run a Stored Procedure named say "spAppData".
This SP will in turn run and delete the entire tables data, and re-insert data into a table we'll call APPS.
Would anyone know how to help me get started on creating a Trigger with the info I've provided?
Thank you,
NBK
To schedule an action, you want a SQL Agent Job to execute your stored procedure at the determined time.
If you are using SQL Express (which does NOT include SQL Agent), you can use a combination of a Windows Scheduler task, SQLCmd.exe, and a Stored Procedure
|||Thank you Arnie. That's just the direction I needed.
Wallace
|||can you please give more details on this.i have same requrement.
thanks in advance
No comments:
Post a Comment