ChristianBahnsen 
10 pts. | Oct 21 2009 4:27PM GMT
I thought express doesn’t support sql agent jobs. Are you saying you can create jobs, store them outside ssms (if yes, where should they be stored?), and run them as scheduled tasks?
Thanks.
Q:
How to create a maintenance plan in SQL Server Management Studio Express
I’m running SQL Server 2005 Workgroup edition with SP2. I’m trying to create a new Maintenance Plan in Microsoft SQL Server Management Studio Express (MSSMSE) by right clicking on the Maintenance Plans object icon. The only option is Refresh - there’s no manual method or wizard.
I'm logging in as sa and my server role is sysadmin. I had already changed the authentication as mixed. I’ve seen lots of posts and they all say I simply need to have the sysadmin server role. But there must be something else, maybe services that need to be running?
I'm logging in as sa and my server role is sysadmin. I had already changed the authentication as mixed. I’ve seen lots of posts and they all say I simply need to have the sysadmin server role. But there must be something else, maybe services that need to be running?
ASKED:
Mar 19 2008 0:00 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
As the Express edition also doesn't include the SQL Agent I usually recommend using the Windows Task Scheduler to run SQL Agent jobs.
