February 9, 2011 at 7:16 pm
hi
i use stored procedure to get values to create chart in my front end . That stored procedure taking more than 10m on server to execute. I planed to execute it every day automatically .
Then i create batch file and made windows Scheduler for it to execute . I saw that process worked fine on my local PC (Windows XP) . But i tried to do that same process (Schedule) on server (windows server 2003) and i check that output . Scheduler not working on WINDOWS server.
So please help me to do this process as different way (need execute stored procedure in given time).
Can i do this using SQL Triggers ?
Can i do this as scheduler on server 2003?
Thanks
February 10, 2011 at 6:39 pm
Have you looked into SQL Agent? That's how I schedule most stuff on SQL Server instances.
"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
February 11, 2011 at 2:26 am
Just checked in Profiler on which stage its stuck
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply