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 |  
                                    | djokerssStarting Member
 
 
                                        28 Posts | 
                                            
                                            |  Posted - 2006-09-27 : 13:03:39 
 |  
                                            | is there a way to make a job schedule that running store procedure for msql express ?i'd like to make a time counter that will update every minute.thanks |  |  
                                    | mightypenny_phYak Posting Veteran
 
 
                                    54 Posts | 
                                        
                                          |  Posted - 2006-11-06 : 06:39:45 
 |  
                                          | unfortunately, from what i've read.  SQL Server 2005 Express doesn't support SQL jobs because SQL Agent is not support.  What Microsoft advised is to used Windows tasks scheduler as the replacement for SQL Agent... Please see link below.  What i've been doing is to create a tasks that will execute a stored procedure or etc using SQLCMD utility.http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspxSlayerS_`BoxeR` + [ReD]NaDa |  
                                          |  |  |  
                                |  |  |  |