|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/14/2011
Posts: 1
|
I have created a job to backup my database and set the scheduling details but when I try to save it I get the following error message: Job scheduling error. The system cannot find the file specified.
It does not mention which file but the job runs fine manually.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Could you please post your *.jobx file?
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
I am afraid that I cant because it will not save it!!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Try to uncheck "Schedule this job" and save again.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
Hi I am not sure if this is it but when I try to save and overwrite the existing one I get the error message.
<?xml version="1.0"?>
<JobInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" JobID="060444ad-4914-4e8f-904d-7846389f2218" AllNonSystemDb="false" TempFolder="" LogFolder="" DbTimeout="10000" UseWebLog="false">
<SqlServer Server=".\SQLEXPRESS" User="" Password="" IntegratedSecurity="true" />
<Databases>
<Database>RFSdata</Database>
</Databases>
<Folders />
<Local Enable="true" Folder="\\Cctv-3035957035\sagebackup" KeepMonths="0" KeepDays="10" />
<Ftp Enable="false" Uri="" User="" Password="" KeepMonths="6" KeepDays="0" DataConnection="Passive" Protocol="FTP" TraceLog="false" />
<Email SendOnDiffSuccess="false" SendOnTranSuccess="false" ZeroConfig="false" Enable="true">
<SuccessMail To="ron.grout@saywell.co.uk" From="no_reply@saywellmail.co.uk" User="no_reply@saywellmail.co.uk" Password="SBFCode:Xa4uLAyOzSiM3ApT4rpLLw==" SmtpServer="smtp.gmail.com" Port="587" SSL="true" />
<FailureMail To="ron.grout@saywell.co.uk" From="no_reply@saywellmail.co.uk" User="no_reply@saywellmail.co.uk" Password="SBFCode:Xa4uLAyOzSiM3ApT4rpLLw==" SmtpServer="smtp.gmail.com" Port="587" SSL="true" />
</Email>
<Run Enable="true" DateTime="2011-09-29T18:08:27" UseService="true" SchedulerAccount="ACCOUNTS-SERVER\Administrator" FullBackupEnabled="true" FullBackupInterval="1440" DiffBackupEnabled="false" DiffBackupInterval="60" LogBackupEnabled="false" LogBackupInterval="0" AutoDeleteOldDiffLog="false" />
<Zip Password="" CompressLevel="Normal" EncryptMethod="Compatible" EncryptStrength="256" ZipToTemp="false" />
<SqlScripting ScriptAlways="false" MaxScriptSize="10000" />
<ScriptBefore />
<ScriptAfter />
<OutputFormat>DateTime</OutputFormat>
</JobInfo>
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
unchecked the schedule this job and it saves OK, check the box again and it fails.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Please check whether "SqlBackupAndFtp Service" is installed on your system
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
I can see it as a process but not as a service, how do I install it as a service?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
It seems that the program tries to install the service before saving the job but fails somewhere. Try to reinstall it.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
Tried re-installing but still the same. No service running unless the machine needs to be rebooted which I cannot do now as it is the accounts server!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Try to install the service running the following command: Code:C:\Windows\system32\sc.exe create "SqlBackupAndFtp Service" binPath= "<path to service in program files>\SbfService.exe" start= "auto" watch the spaces in the command!
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
Not having much luck here, the file sc.exe does not exist on this computer!!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
So, that's the root of the problem. What OS is installed on your computer?
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 733
|
Perfect, that did it.
Thank you. :)
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
|
|
|
|
|
