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 |
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-01-21 : 00:50:58
|
hi,mine is a sql server 2005 express edition and want to create sql jobs for that iam lacking sql server agent in my installed sql server express edition.any other alternative to get back the sql server agent in this for creating sql jobs?any other free tools too?Thanks,Rajasekhar |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-21 : 08:46:49
|
SQL Server express , does not ship with SQL Server agent . You could use a third party command line scheduler , which executes SQLCMD type commands . For example : SQLCMD -E -S My_sql_server -i c:\myplan.sql You would write the commands in the c:\myplan.sqlJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-01-25 : 02:11:20
|
hi i created myplan.sql file and run the command now iam getting asSqlcmd: Error: Microsoft SQL Native Client : An error has occurred whishing a connection to the server. When connecting to SQL Server 2005,re may be caused by the fact that under the default settings SQL Serve allow remote connections..Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-26 : 08:24:34
|
1)the "-E" switch means it's tring to use Windows Authentication , if you want to use SQL authentication do something like :SQLCMD -U myUsername -P myPassword -S My_sql_server -i c:\myplan.sql make sure you have authntication for that logon2)Ensure you ahve "allow remote connections" turned onJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|