Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Jobs & Tasks


Search:
What's New - What's Hot
Scheduling Jobs in SQL Server Express     
Total Hits: 117  |  Today: 0Author: Mladen Prajdić      Rating:  
Read Reviews | Write Review |  Your Rating: 

As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed due to the security policies of many hosting companies and thus presents a problem. Maybe we want to schedule daily backups, database reindexing, statistics updating, etc. This is why I wanted to...

SQL Server Agent Job Ownership     
Total Hits: 294  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I am making a number of SQL Server security changes at the server and database level all at once, which is a problem in and of itself. I will be changing SQL Server service accounts, removing rights to BUILTIN\Administrators group, limiting specific user rights, moving to group based security, changing SQL Server Agent Job owners, etc. Nevertheless, I want to prevent as many issues as possible with so many simultaneous changes. One issue (of many) that I am concerned about is related to SQL Se...



Disclaimer - Privacy
© 2002-2017 DevASP.net