Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

creating and scheduling a job in sql server 2005 Expand / Collapse
Author
Message
Posted Thursday, August 6, 2009 9:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244
I have to periodically delete data from a table thats over a certain age. I can create a stored procedure that would do this, but how do I create a job and schedule it so that it executes the stored procedure at a predetermined time each day ?
Post #766333
Posted Thursday, August 6, 2009 10:07 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:45 PM
Points: 1,143, Visits: 1,002
it's easy to implement. look in books online (help) under the topic "jobs [SQL Server Agent]"
Post #766363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse