Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
corgiii
Starting Member
4 Posts |
 Posted - 2010-02-16 : 08:10:20
|
| im using sql 2005, how do i exec a stored procedure every 12 hours? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 08:11:45
|
Set up a Job, with a Schedule, in SQL Agent.(If you are using SQL Express it does not come with SQL Agent  ) |
 |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-16 : 09:49:54
|
| If you are using SQL Express, set up a scheduled task in Windows to run sqlcmd from a batch file every 12 hours. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 10:20:58
|
Less painful to just buy a copy of SQL Server I reckon  |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
corgiii
Starting Member
4 Posts |
Posted - 2010-02-16 : 10:29:36
|
| does anyone know how to open sqlagent in sql 2005? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 10:40:18
|
| Its in SSMS - right down the bottom of the object tree in the left pane - it will be missing if you have SQL Express. |
|
|
|
corgiii
Starting Member
4 Posts |
Posted - 2010-02-16 : 10:46:20
|
| its not there, im using SQL express |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 11:04:18
|
| Well like I said in my first post: "If you are using SQL Express it does not come with SQL Agent" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
updating table?