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 |
|
harpreetkaur
Starting Member
14 Posts |
 Posted - 2007-02-13 : 23:20:20
|
| I just upgraded from msde to sql express and need a way to run my existing jobs. I tried sqlschedular but dont seem to get it to work. How can I access or run my existing jobs. Help is appreciated |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-13 : 23:41:31
|
| there is no sql agent for SQL Express. You will need to execute scheduled jobs using the Task Scheduler built into your OS. You can get there (on winxp) by going to Start --> control Panels --> Scheduled Tasks-ec |
 |
|
|
harpreetkaur
Starting Member
14 Posts |
Posted - 2007-02-15 : 12:18:18
|
| I had like 10 different job when I was on msde and could view them under management-->sql server agent-->jobs in msde.Will I need to create batch files using sqlcmd to run each backup command or run a stored procedure or can i simply schedule my existing jobs.Is there a way to run a already created job. Help with syntax needed thanks |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-15 : 12:51:25
|
quote:
Originally posted by harpreetkaur
I had like 10 different job when I was on msde and could view them under management-->sql server agent-->jobs in msde.Will I need to create batch files using sqlcmd to run each backup command or run a stored procedure or can i simply schedule my existing jobs.Is there a way to run a already created job. Help with syntax needed thanks
yes, you will have to create batch jobs or vbscripts or powershell scripts to execute your sql jobs. Google around and you should find some information and code on how this can be accomplished.-ec |
|
|
|
|
|
|
SQL Schedular to run jobs