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 |
|
jadeite100
Starting Member
5 Posts |
 Posted - 2010-10-07 : 23:25:13
|
| Hi All:I am currently using Windows 2003 R2, Standard Edition.I have Microsoft Sql Server 2005 Installed with the latest service pack which is sp3.I logged into the operating system as an administrator. The windows administrator id is "test2".I logged into the Microsoft Sql Server 2005 database using "Microsoft Sql Server Management Studio" as an "sa" which is database admin.I placed a bat file called "test1.bat" in the directory c:\test3, the file "test1.bat" contains the following content:sqlcmd -b -e -Q "ALTER INDEX ALL ON [JOHNDATABASE].dbo.TABLE2 REBUILD"In the dos-prompt, I can run the "test1.bat" batch file with no errors.It gives me the following output:c:\test3\sqlcmd -b -e -Q "ALTER INDEX ALL ON [JOHNDATABASE].dbo.TABLE2 REBUILD"ALTER INDEX ALL ON [JOHNDATABASE].dbo.TABLE2 REBUILDUsing "Sql Server Agent", I created a new job called "Scripts1".For the "General" link, I have the following values:Name:test2Owner:SACategory:Database MaintenanceFor the step link, I have the following values:Step Name:test2Type:Operating system(CmdExec)Run As:SQL Agent Service AccountCommand:sqlcmd -b -e -Q "ALTER INDEX ALL ON [JOHNDATABASE].dbo.TABLE2 REBUILD"When, I right click the job "test2" and click "Start Job at Step..", when I view History I get the following error:The job failed. The Job was invoked by user DOMAIN\test2. The last step to run was step 1[test2]Executed as user. LCA1-B-W-Q-WEB2\SYSTEM. The process could not be created for step 1 of job 0x4EC27C08D25E94(reason: The system cannot find the file specified). The step failed.Any help or hint is greatly appreciated.Yours,Frustrated. |
|
|
|
|
|
Sql Server Agent failed to executed a scheduled ba