March 10, 2009 at 1:15 am
Hi Friends,
this is second time I'm here. I would like to know is there scheduler services or anything similar in SQL Server 2005?
I need to track the table status after regular time interval. I'm not sure whether trigger can do so because this activity is irrespective of table updates.
Thanks,
Vicky
March 10, 2009 at 2:05 am
Look in books on line for information about creating jobs. You can define a job and schedule it to run whenever you want.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 10, 2009 at 5:59 am
The jobs are created in the SQL Server Agent. It's a seperate service that runs along side SQL Server (assuming you're not running Express). It allows for scheduling to run backups, maintenance, t-sql commands like what you want.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 10, 2009 at 6:13 am
I don't need Scheduled Jobs on server, rather I need similar functionality but at database level.
I need to check the row count of a table after every 3 hours. Is there something like this?
-Vicky
March 10, 2009 at 6:18 am
It sure sounds like that's what you need. Yes, it's running on the server, but so is your database. You just point the scheduler at the DB you want and run it.
There is no database only scheduling process. If you need something run on a timed basis, Agent, or some third party scheduling tool, is the way to go.
If there's a status concern, rather than checking for the status, why not put a trigger in place that does something when the status changes? That would seem to work better than polling over & over. Then it would be internal to the database and wouldn't require scheduling.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply