Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005 ASP
Hi all
I created one trigger for deleting records.now please tell me how to call a trigger after every 30 min ...
Posted 14-Aug-12 1:07am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Please refer the link
http://databases.about.com/od/sqlserver/ss/sql_server_agent.htm[^]
that describe creation of job step by step in wizard formate.
 
hope will help this.
  Permalink  
v2
Comments
snehasish nandy at 14-Aug-12 7:44am
   
Thank u..
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can Schedule a Job in sql server for the same.
  Permalink  
v2
Comments
snehasish nandy at 14-Aug-12 7:31am
   
what are the steps please tell me how to do that
aspnet_regiis at 14-Aug-12 7:54am
   
http://www.codeproject.com/Answers/440270/how-to-call-a-stored-procedure-autometically#answer3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 375
1 Richard Deeming 240
2 _Amy 205
3 CHill60 195
4 Nirav Prabtani 178
0 OriginalGriff 8,104
1 Sergey Alexandrovich Kryukov 7,045
2 Maciej Los 4,039
3 Peter Leow 3,738
4 CHill60 2,912


Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 14 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100