Navigation
Home
Products
Articles
About Us
 

SQL Scheduler Feedback

Category: LazyCoding.com - SQLScheduler Posted On: March 15, 2007


We want to hear from you any suggestions or comments about the SQLScheduler. Help us improve.

What would you like to have in the next version?

 

Feedback by other visitors of LazyCoding.com

On Tuesday March 27, 2007 08:56:54 Dan Rostron said:

Great product! Thanks very much. Before using this software I tried several other SQL Agent types of programs, but found many bugs in them - and not quite doing what I was after.

However, after coming across your product, I thought I would give it a go. I found the installation an absolute breeze compared with similar software. Implementing my scripts was just as easy - no need for any in-depth scripting. Just simply enter your SQL commands, and away you go. The ability to be able to email yourself when the task fails is a great benefit as well.

Keep up the good work, and thanks again!
Dan Rostron

On Wednesday March 28, 2007 08:21:38 LazyCoding.com said:

Hi Dan,

Thank you very much for kind words. It's been our pleasure.

Cheers...

On Wednesday March 28, 2007 11:24:23 Myles said:

Thanks got it working.

What does this:
(Severity 0, state 1, error number 3211, line 7)

mean ? I'm using the template.

On Wednesday March 28, 2007 12:11:57 LazyCoding.com said:

These are just informational messages/warnings.

More information on severity, states, and errors numbers can be found here:

http://www.sommarskog.se/error-handling-I.html#anatomy

On Monday April 16, 2007 12:24:54 Nathan Bedford said:

Great product...I've used SQLScheduler at a couple client sites to run some backup scripts. You've inspired me to release some of my little .NET utilities as free instead of charging :)

As far as suggestions, I have two:

1) As it is, the installation is quite simple...however, I think a little installer would be nice. If you'd like, I can work on one in NSIS or InnoSetup and post it.

2) Can you create a script repository, so users like myself can submit various scripts that we've found useful (scripts to use with SQLScheduler, of course)? For instance, I made a little script that will rotate between two backup files (one for even weeks, one for odd weeks). The script will start will a full backup on the first day of the week, and they do incremental backups every other day. This way, you'll have anywhere from 7 to 14 days of backups to restore if you need to.

Anyways, that's my 2cents. Thanks again for a great free product!

On Wednesday May 23, 2007 04:12:29 Deon Nel said:

My first impression is that this product has the makings to be a Excellent tool for the DBA.

1. What would be nice is if one right click on the job to be able to see the jobhistory e.g. Failed/Succ and execution times.
2. When selecting the job nothing displays in the right side window, maybe detail of that specific job would be nice.
3. An option when selecting servers to display all the jobs on all the servers would also be nice.

Thanx very much for such a neat and clean product.

On Friday May 25, 2007 01:06:49 Oliver Tung said:

Excellent product, guys! Very well done.

Just one suggestion, it would be great if it is able to perform a backup to a remote network drive. Support of the UNC network path format would be ideal.

Thanks for such a handy product! :)

On Wednesday June 13, 2007 02:01:00 Sam Rahimi said:

Thanks guys - you saved me lots of work doing a scheduled backup for SQL Express... it was literally 5 minutes from unzip to daily scheduled backup job.

On Wednesday June 13, 2007 02:33:38 LazyCoding.com said:

Oliver,

Being able to backup to UNC path is already possible. You just need to make sure that proper permissions are given to the account under which SQL Server is running.

On Wednesday June 13, 2007 02:33:55 LazyCoding.com said:

Sam,

You are welcome.

On Friday June 15, 2007 12:06:20 Mike said:

Hey guys... Thanks so much for making this tool... it is a must-have for those of us poor schleps running 2005 Express! :) I would like to add a comment/suggestion for a future release. Perhaps an option that keeps track of the number of backups it makes and is able to trim (delete) old backups so a certain number remain. Lets say you just want to keep 30 days worth of backups in a backup folder... making it so SQL Scheduler trims the oldest backup out of this folder to keep it going with just 30 backup files. That would be great... that's the only thing I see missing. UNC paths would also be very cool... agreed!

On Wednesday June 27, 2007 03:53:24 Johan S said:

Nice tool :
What about adding jobs that have no time shedule ,just to be run manually , like executing scripts to do a restore or other kind of scripts

Also an import, export feature for the config files would be a nice extra.
Regards, Johan

On Thursday June 28, 2007 12:02:00 LazyCoding.com said:

Mike,

All these features are already available (indirectly). Don't forget that the SQLScheduler's job is to execute provided SQL scripts every 'xx' amount of time. This is an example of one of the back up jobs that we run daily on one of our servers:

-- **********************************************************
use somedatabasename

DECLARE @BackupName VARCHAR(100)
DECLARE @BackupFileName VARCHAR(100)
DECLARE @BackupPath VARCHAR(1000)

SET @BackupName = 'SOMENAME_' + convert(nvarchar(20), getdate(), 112)
Set @BackupFileName = @BackupName + N'.bak'
SET @BackupPath = N'S:\BackUps\foldername\' + @BackupFileName
BACKUP DATABASE somedatabasename TO
DISK = @BackupPath WITH NOFORMAT, NOINIT,
NAME = @BackupFileName, SKIP, REWIND, NOUNLOAD, STATS = 10

DECLARE @ArchiveName VARCHAR(1000)
Set @ArchiveName = 'S:\Backups\foldername\archive.bat ' + @BackupName

exec xp_cmdshell @ArchiveName

-- ********* END ***********


The contents of the achive.bat are as foll

On Thursday June 28, 2007 12:02:36 LazyCoding.com said:

The contents of the achive.bat are as follows:


cd drive:\somedirectory\path
"C:\Program Files\WinRAR\rar.exe" a -df -rr1 %1 %1.bak


What the script does is it backups a database and then runs rar.exe to compess the resulting backup file.

The batch file can also include lines to delete old backups, or move the files somewhere else.

BTW UNC path backups have nothing to do with the SQLScheduler.

You just need to do :

BACKUP DATABASE somedatabasename TO
DISK = \\servername\sharename WITH NOFORMAT, NOINIT,
NAME = backupname, SKIP, REWIND, NOUNLOAD, STATS = 10

The key is to make sure that whatever Windows account the SQL Server is running under has write writes to the UNC share.



LazyCoding.com

On Thursday June 28, 2007 12:07:55 LazyCoding.com said:

Johan,

To run a job manually, just select a job, right click and choose Execute, additionally you can uncheck the "Enabled" box under the job's Properites to prevent a job to be scheduled.

The configuration information is stored in the XML format in the file called jobs.config. This file can be copied to any other machine to provide export/import like functionality. However, the 'secrets' - connection string passwords cannot be "exported" because they are encrypted with the machine specific key, so the passwords would have to be retyped manually, once jobs.config is exported to a different computer.

Hope this helps,

-LazyCoding.com

On Wednesday July 18, 2007 12:33:56 Barrie said:

Don't you just love it when something just works!

Excellent bit of software and very useful for one of my current projects.

On Sunday July 22, 2007 05:06:29 Misiek said:

Hi,

Very nice tool :-) Thanks for it!

My questions:
Is it possible to perform operations like add server/jobs using SQLScheduler.Scheduler.dll public interfaces? In spite of I would prefer to do it from my own application. If yes, could you please provide a short tutorial how to do it?

Best regards

On Wednesday July 25, 2007 01:01:14 LazyCoding.com said:

Misiek, You need to register the SQLScheduler.Scheduler.dll in your application. Then all the main functions can be accessed through the static instance of the "ServiceFactory.JobService" class.

The ones of interest are:

ObjectCollection GetServers();
ObjectCollection GetJobs(string serverName):
void SaveServer(string serverName, ServerObject server)
void SaveJob(string serverName, string oldJobName, JobObject job)
void StartJob(string serverName, string jobName)

The only downside is that you need to setup the IPC remoting in the config file (same way as the SQLScheduler.Client) and your application must be running on the same machine as the SQLScheduler Service (unless you reconfigure Remoting to use TCP or HTTP).

Hope this helps

-LazyCoding.com

On Thursday July 26, 2007 11:54:09 Kamal said:

I just installed this and found it very easy to use. It seems to work well and the documentation was just detailed enough to make it a snap to setup. Great job and thank you!!

- K

On Friday July 27, 2007 01:08:39 Kool said:

Very kool product. Great job!

On Monday August 06, 2007 04:40:07 Laura said:

Great piece of software! The error numbers in the "Last Run Result" threw me off until I learned that with a severity of 0, they are merely informational or a warning. The same code runs without error in a SQL Server Express Query, so all is well. This article (referenced in a previous post) put my worries to rest: http://www.sommarskog.se/error-handling-I.html#anatomy

Thank you for offering such a useful tool at no cost!

On Thursday August 16, 2007 04:40:42 Jonathan said:

Very simple. Very easy to install, configure, and use. I agree with Deon Nel's comment... A more advanced job history (with filters, sorting, searching, statuses, output, etc.) would be nice. Really, a great job. dotNET makes development easy, no?

On Wednesday September 05, 2007 01:16:01 Pedro Carvalho said:

Great stuff. Easy to setup and get going. Only a minor hitch: not to be able to setup the smtp port. Apart from that seems a really promising tool.

On Thursday September 06, 2007 08:23:17 LazyCoding.com said:

Pedro,

You can change the SMTP port in the config file of the SQLScheduler service:

<smtp deliveryMethod="Network" from="sqlscheduler@somedomain.com">
<network host="somesmtpserver.com" userName="" password="" Port="2525" />
</smtp>

On Monday September 24, 2007 08:57:12 Russ Lunn said:

Brilliant piece of software.
i am wondering if i can distribute it with a database and then just change the server and have all the jobs then run against the new server?

Regards,

Russ

On Wednesday September 26, 2007 10:31:48 Vince said:

Handy piece of software and very easy to configure. Good job and thanks for making it available.

On Friday November 02, 2007 01:46:32 Yulia said:

I get an error when runing the following script with SQL Scheduler:

DECLARE @BackupName VARCHAR(255)
DECLARE @BackupFileName VARCHAR(255)

SET @BackupName = 'BESMgmt_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = N'C:\SQL Backup\' + @BackupName

BACKUP DATABASE BESMgmt TO
DISK = @BackupFileName WITH NOFORMAT, NOINIT,
NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10


Error:

Severity 0, State 1, error number 3211, line 7

Is that a critical error?

On Friday November 02, 2007 01:57:34 Yulia said:

Full error:

Processed 1776 pages for database 'BESMgmt', file 'BESMgmt_data' on file 1. (Severity 0, state 1, error number 4035, line 7)
100 percent processed. (Severity 0, state 1, error number 3211, line 7)
Processed 4 pages for database 'BESMgmt', file 'BESMgmt_log' on file 1. (Severity 0, state 1, error number 4035, line 7)
BACKUP DATABASE successfully processed 1780 pages in 0.563 seconds (25.894 MB/sec). (Severity 0, state 1, error number 3014, line 7)

On Friday November 02, 2007 10:49:37 LazyCoding.com said:

Yulia,

Please see the top 3-4 comments. These are just informational messages.

On Wednesday November 14, 2007 02:21:09 Laurel said:

Thanks for such a handy software! I have two suggestions here:

1. Is it possible to add a schedule option "run once when service starts up" (at the moment you have to set a specific start time)?
2. Is there any way to export the scheduled jobs into a file (similar to an .sql) so it can be imported to another database or server later?

Cheers,
Laurel

On Monday November 19, 2007 04:12:19 Jim Moss said:

Is is possible to use IP rather than named pipes with SQL Scheduler?

On Tuesday November 20, 2007 07:50:43 LazyCoding.com said:

Jim,

Are you referring to the connection between SQLScheduler Server vs Client or the connection to a SQL Server instance?

In the first case, theoretically it is possible, but practically we haven't tried it and would never recommend it since natively .Net Remoting does not support authentication (unless the whole thing is hosted in IIS).

In the last case, you can use ip address, Netbios name, fully qualified name, theoretically anything that can be resolved to a valid SQL Server isntance.

Cheers,

-Lazycoding

On Wednesday November 21, 2007 08:28:27 Jim Moss said:

What I'm referring to is the error email below. The server does allow remote connections, but SQLScheduler is running on the server but only IP is enabled:

Job Execution Log:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Thanks for your help with this issue and the application.

Jim Moss

On Wednesday November 21, 2007 11:16:45 Jim Moss said:

This app works great after I appended the \sqlservername to the end of the IP address... DUH.

Thanks for the great scheduler!

Jim

On Tuesday December 11, 2007 01:04:18 Caltrans_Jim said:

Awesome piece of software! It's not very often you see such a clean app that works so well.

I have a question. Local network policy forbids SMTP communication on the server, outside of certain registered .exe's. The SQL Scheduler app is being shot down when it tries to e-mail me job results. Any way to map the app through the config file to use a more common SMTP executable, such as inetinfo.exe or wscript.exe?

Yeah, it's probably a dumb question.

On Wednesday December 12, 2007 05:00:09 Jonathan said:

Firstly, awesome product. 2 m 20s from unzipping to having my first 'success' notification on a scheduled job. I have never paid for a product that installed so easily and worked as i expected, let alone got one for free. All the options are intuitive and where you expect to find them. it just does what it should. properly.

a couple of possible extras i would add
- when you navigate down the tree view on the left and reach a job that the right hand panel show the history of the job, with maybe a clickable 'drill through' to see details of each run ...
- the option to pick and edit a schedule already in use on a previous job, just to save time and ease admin.

On Wednesday December 12, 2007 08:17:43 LazyCoding.com said:

Jim,

Thank you for the kind words.

Sqlscheduler.exe sends the emails directly to the mail server using the .NET Framework, changing it to use a third-party application would require too much development effort without really any visible benefit in most cases.

I can only suggest a couple of things, which may or may not work depending on your environment:

1) Configure the mail server to accept mail on an different port (2525, etc.). This might work depending how the "security policy" determines SMTP communication and if you have access to the mail server.

2) The other solution, which I haven't tried myself but it should might work depending on the security configuration, is to install SMTP add-on for IIS on the machine running SQLScheduler and then relay the mail through it. You also might have to change the default SMTP port to something else.

In the end, without knowing the exact configuration of your "security policy" and by what means it is enfor

On Wednesday December 12, 2007 08:18:16 LazyCoding.com said:

ced (Windows, firewall, antivirus software, etc.), it is hard to make an accurate suggestion.

Hope this helps.

On Wednesday December 12, 2007 12:42:28 Jim said:

Dude, you are a rock star.

I'm running Windows Server 2003 with VirusScan Enterprise. There is a specific block on port 25, with the exception of certain allowed programs which are centrally authorized by policy. We are already running the local SMTP server through IIS.

Configuring the IIS SMTP server to accept mail on an alternate port did the trick. Thank you for the advice!

On Tuesday January 08, 2008 04:01:35 Asiimwe said:

From the user comments above, it should a nice a tool. However i have a problem installing the tool, when i ran the installservice.bat file,
i get the messages below.

"The Installation failed, and the rollback has been perfomed.
System error 3 has occurred.
The system can not find the path specified.
Done.
Press any key to continue"

Still when i go to windows administration tasks, services, i can see the SQLScheduler service and its configured to start automatically.
I i right click it and try to start it, i get the error message below.

"Could not start the SQLScheduler Service on local computer. The system can not find the specified path."
Any ideas why this is so what i can do.

On Tuesday January 08, 2008 04:13:58 Asiimwe said:

AND BELOW IS THE LOG FILE IF THIS IMPROVES HELP CHANCES.

Running a transacted installation.

Beginning the Install phase of the installation.
See the contents of the log file for the C:\SQLScheduler_LatestVersion\Service\SQLScheduler.WindowsService.exe assembly's progress.
The file is located at C:\SQLScheduler_LatestVersion\Service\SQLScheduler.WindowsService.InstallLog.

An exception occurred during the Install phase.
System.ComponentModel.Win32Exception: The specified service already exists

The Rollback phase of the installation is beginning.
See the contents of the log file for the C:\SQLScheduler_LatestVersion\Service\SQLScheduler.WindowsService.exe assembly's progress.
The file is located at C:\SQLScheduler_LatestVersion\Service\SQLScheduler.WindowsService.InstallLog.

The Rollback phase completed successfully.

The transacted install has completed.

On Tuesday January 08, 2008 11:22:32 LazyCoding.com said:

Asiimwe,

What kind of .NET Framework version do you have installed on your machine? Generally SQLScheduler requires .NET v2.0.50727.

Just open the "installservice.bat" file and make sure that the path "%SystemRoot%\Microsoft.NET\Framework\v2.0.50727" exists on your machine. Most likely your version of the .NET Framework is different, so just change the file path to whatever version you have.

Hope this helps.

On Thursday January 17, 2008 11:19:22 Neil Robins said:

Thank you for a very useful utility. The backup works great for me but I am having trouble trying to zip it. The archiving program is picking up @BackupName as part of it's executable name and I get an e-mail telling me the backup was successful but also saying: "OUTPUT 'C:\SQLfolder\Backups\archive.batSOMEBACKUP.bak' is not recognized as an internal or external command,
operable program or batch file. I am using

DECLARE @ArchiveName VARCHAR(1000)
Set @ArchiveName = 'C:\SQLfolder\Backups\archive.bat' + @BackupName

which I think is what you specify. Your assistance greatly appreciated.

On Friday January 18, 2008 11:40:39 LazyCoding said:

Neil,

I think you are missing a space after archive.bat file:

'C:\SQLfolder\Backups\archive.bat<INSERT A SPACE HERE>' + @BackupName

On Tuesday January 22, 2008 02:53:24 Eddie said:

What are the limitations as far as distributing this app? in your post:
[quote]You need to register the SQLScheduler.Scheduler.dll in your application. Then all the main functions can be accessed through the static instance of the "ServiceFactory.JobService" class.[/quote]

How would I be able to do that in a Delphi application? Needs either ActiveX or TLB for import.

On Tuesday January 22, 2008 04:31:00 Eddie said:

Instead, can I just manipulate the config file? If so, how do you compute the ID for a job?

<jobs>
<add id="81A966265AC14F0AA86A81E6168F0005" name="Test Job" description="Just a test job"
...interval="1" scriptTimeout="15" intervaltype="Day">
<operators>
<clear />
</operators>
</add>
</jobs>

On Friday January 25, 2008 05:38:55 Happy User said:

You guys simply rock!

More precisely: I have limited skills when it comes to scripting SQL Server. As an user of SQL Server Express in need of a regular backup I was very challenged in trying to create a backup routine using the scripts that are available online. I had my backup up and running in 15 minutes to a UNC path at that. Did I mention that you guys rock? Thanks for an outstanding product.

On Thursday February 28, 2008 05:28:36 Stuart said:

This is great tool but when I'm checking for sucess/failure having the word "error" in the log file makes it hard to use simple text filtering. When its sucessful I get the following BACKUP DATABASE successfully processed 11411 pages in 41.717 seconds

What would I see if it had failed?

On Saturday March 08, 2008 10:21:49 Hans said:

Hi.

When i been install the service, throws identitynotmappedexception, any ideas ? :- s

On Wednesday March 12, 2008 09:03:35 LazyCoding.com said:

Hans,

Make sure that in the SQLScheduler.WindowsService.exe.config file, attribute "authorizedGroup" points to a valid Windows group in your Worksgroup/Domain. Usually If you are running a non-English Windows, group 'Everyone' is called differently.

On Sunday March 16, 2008 03:10:33 Jags said:

Yes. Will agree with everyone here....Great Product. Not a SQL person myself but was able to figure out everything I needed to do.
Only thing I cannot seem to get to work is sending email notification. This is what I added in the config file.

<system.net>
<mailSettings>
<smtp from="sqlscheduler@somedomain.com">
<network host="smtp.mymail.com" password="password" userName="user@mymail.com" port="25" defaultCredentials="false"/>
</smtp>
</mailSettings>
</system.net>

Am I doing it right? This is the same part I am using in my asp.net application and its working fine.

If I add smpt tags to the existing config file without the system.net wrapper, I get an error.

Will appreciate any feedback.

Thanks and Great Work....

On Monday March 17, 2008 09:39:49 LazyCoding.com said:

Jags,

Make sure that the SMTP settings are present in the SQLScheduler.WindowsService.exe.config file. It sounds that you might be putting them into the Scheduler.exe.config.

On Thursday March 20, 2008 02:17:16 Nchavarria said:

This is great tool
Thanks, you save my life

On Thursday March 27, 2008 04:41:33 Dave S. said:

You have saved my life as well. SQL Agent is by far the most significant thing omitted from SQL Express, and your program is the only worthwhile option that I have found, including commercial options. I would send you money if you had a "donate" button on your site.

Your program is simple, effective, and it works reliably.

Thanks a MILLION for your work.

Dave

On Tuesday April 15, 2008 05:23:25 J said:

Can I get some help in running a stored procedure from SqlScheduler?

On Thursday April 17, 2008 01:48:32 Julius Remigio said:

I am using this product on several of my client's machines. It's great!

Some features that I think would be really cool would be thw following:

-command line interface
-getting rid of machine ids - i'd like to be able to simply replace the xml file with the stored jobs for all of my clients with a single file without having to add the jobs on every single computer with the scheduler.

Thanks!

On Tuesday April 29, 2008 06:07:15 Velickovski Dragan said:

I'm using your product, great product, keep going ...

I need to schedule job daily, but to run on specific time (not on midnight )

How I can do that?

On Wednesday April 30, 2008 01:47:17 LazyCoding.com said:

Dragan,

You can set the time on the job's property dialog.

On Wednesday April 30, 2008 03:08:46 Velickovski Dragan said:

Tanks!

On Thursday May 15, 2008 10:48:46 Joshua B said:

This is a great addition to a SQL Express install. Haven't had any problems with it for over a year now.

On Wednesday May 28, 2008 06:46:46 Dougie said:

I'd also like to know how to have SQLScheduler run a Stored Procedure

On Wednesday June 04, 2008 05:10:14 Shaun said:

Great tool!!

I must admit that the lack of a setup.exe and the simple UI had me a bit concerned that this product was like 1000 other mickey-mouse free tools, but after using it I am 110% satisfifed. It is very rare to find a free tool that works so well. Here are a couple of suggestions:

1) Create a setup program.
2) When a job node is selected in the Servers tree, show some basic job info in the Listview (i.e. Last Run, Next Run, Last Result, etc)
3) Add a "Copy Job" feature to allow users to create a job from another job.

Again, great job! Thanks for offering this for free.

On Thursday June 19, 2008 10:24:55 Mark said:

I am new to this tool, it is a very nice tool. I have the following SQL script that I would like to run scheduled:

INSERT INTO table1 ( ID1 )
SELECT table2.ID2 FROM table2;

UPDATE table1 SET table1.table1date = CONVERT(VARCHAR,GETDATE(),101)
WHERE table1.table1date Is Null;

How do I go about this?

On Sunday July 13, 2008 10:31:15 Cranky said:

Fantastic tool! I know NOTHING about SQL and this has made backing up the databases for my 3 stores a breeze!

One thing i would love to know is how to make incremental backups? At the moment it is making a full backup of my database each day. This is great for security but terrible for disk space :) Can anyone tell me what syntax i should use to do incremental backups please?

Here is what i am using currently:

DECLARE @BackupName VARCHAR(255)
DECLARE @BackupFileName VARCHAR(255)

SET @BackupName = 'springwood_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = N'c:\SQLBackups\' + @BackupName

BACKUP DATABASE springwood TO
DISK = @BackupFileName WITH NOFORMAT, NOINIT,
NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10

thanks!!

On Wednesday July 23, 2008 11:27:06 Sophia said:

http://1991hondaprelutesr.bloghi.com http://1991hondapreludesiengine.bloghi.com http://1991hondapreludespeedometercable.bloghi.com http://1991hondapreludesicombinationlight.bloghi.com http://1991hondapreludesirims.bloghi.com http://1991hondapreludeupperballjoint.bloghi.com http://1991hondapreludetuning.bloghi.com http://1991hondapreludesi205parts.bloghi.com http://1991hondapreludemasterwindowswitch.bloghi.com http://1991hondapreludeparts.bloghi.com http://1991hondareapirmanual.bloghi.com http://1991hondapricesuk.bloghi.com http://1991hondapreludesichiltonmanual.bloghi.com http://1991hondapreludesib20a.bloghi.com http://1991hondaquada.bloghi.com http://1991hondapreludesrcartroubles.bloghi.com http://1991hondapreludeperformanceparts.bloghi.com http://1991hondapreludewaforsale.bloghi.com
http://1991hondapreludemodifications.bloghi.com

On Sunday July 27, 2008 02:10:10 Joan said:

ac9d49ce38e519247d95219dbc22789f
<a href="http://njdokj.info/0a24479b5982f33b33c8c0f96819c84f/ac9d49ce38e519247d95219dbc22789f"> http://njdokj.info/0a24479b5982f33b33c8c0f96819c84f/ac9d49ce38e519247d95219dbc22789f </a>
http://njdokj.info/0a24479b5982f33b33c8c0f96819c84f/ac9d49ce38e519247d95219dbc22789f
[url]http://njdokj.info/0a24479b5982f33b33c8c0f96819c84f/ac9d49ce38e519247d95219dbc22789f[url]

On Tuesday August 05, 2008 06:42:54 RDCPro said:

Fantastic tool! This is so much easier to use than "task scheduler" and SQLCMD, and I love the email notifications! I'm using it to run backups on SQL Server 2005 Embedded Edition (with Windows SharePoint Services), which doesn't come with any way to manage the database or set up a maintenance plan. SQLScheduler lets me treat MSEE like SQL Server Standard Edition! After screwing around for HOURS with what few built-in tools there were, I tried SQLScheduler to do it, and everything worked right the first time. Way cool!

Great job, guys!

Mike

On Thursday August 07, 2008 06:36:59 Georg said:

Hi,

Like the tool a lot, just a few suggestions.
1.One can't copy and paste into the SQL Details box.
2.One can't copy the jobs.cfg file to another PC's to run the same set of jobs there.


Otherwise greta stuff,

Georg

On Friday August 22, 2008 06:04:14 QrA said:

hello. great tool! thanx VERY much for this.

but i have one problem:

All backups created by program are 136 MB in size. I've scheduled 2 jobs for full backup of two different databases on one server. When i manually back up one database directly form SQL Server Management Express it has 136 MB - same as SQL Scheduler backup. It's ok. Restore works fine.

BUT

Another database backed up manually has 366 MB, and with SQL Scheduler - 136 MB (i am talkin about full backups). I can restore this database with no errors but i am worried about content of database - i cant be sure is there everything ok, and nothing is missing. Can you help me with this? How can I create full size backups by SQL scheduler?

My SQL query for this second job:

DECLARE @BackupName VARCHAR(100)
DECLARE @BackupFileName VARCHAR(100)
DECLARE @BackupPath VARCHAR(1000)

SET @BackupName = 'euro_anna-' + convert(nvarchar(20), getdate(), 112)
SET @BackupFileName = @BackupName + N'.bak'
SET @BackupP

On Friday August 22, 2008 06:05:31 QrA said:

My SQL query for this second job:

DECLARE @BackupName VARCHAR(100)
DECLARE @BackupFileName VARCHAR(100)
DECLARE @BackupPath VARCHAR(1000)

SET @BackupName = 'euro_anna-' + convert(nvarchar(20), getdate(), 112)
SET @BackupFileName = @BackupName + N'.bak'
SET @BackupPath = N'E:\_backup\Sello\' + @BackupFileName

BACKUP DATABASE euro_kom TO
DISK = @BackupPath WITH NOFORMAT, NOINIT,

NAME = @BackupFileName, SKIP, REWIND, NOUNLOAD, STATS = 10

Can I change something here to get it to work?

Also in Result Log i get similar text:

10 percent processed. (Severity 0, state 1, error number 3211, line 9)
20 percent processed. (Severity 0, state 1, error number 3211, line 9)
30 percent processed. (Severity 0, state 1, error number 3211, line 9)
40 percent processed. (Severity 0, state 1, error number 3211, line 9)
50 percent processed. (Severity 0, state 1, error number 3211, line 9)
60 percent processed. (Severity 0, state 1, error number 3211, line 9)
70 percen

On Friday August 22, 2008 06:05:50 QrA said:

Also in Result Log i get similar text:

10 percent processed. (Severity 0, state 1, error number 3211, line 9)
20 percent processed. (Severity 0, state 1, error number 3211, line 9)
30 percent processed. (Severity 0, state 1, error number 3211, line 9)
40 percent processed. (Severity 0, state 1, error number 3211, line 9)
50 percent processed. (Severity 0, state 1, error number 3211, line 9)
60 percent processed. (Severity 0, state 1, error number 3211, line 9)
70 percent processed. (Severity 0, state 1, error number 3211, line 9)
80 percent processed. (Severity 0, state 1, error number 3211, line 9)
90 percent processed. (Severity 0, state 1, error number 3211, line 9)
Processed 17496 pages for database 'euro_kom', file 'szef' on file 1. (Severity 0, state 1, error number 4035, line 9)
100 percent processed. (Severity 0, state 1, error number 3211, line 9)
Processed 1 pages for database 'euro_kom', file 'szef_log' on file 1. (Severity 0, state 1, error number 4035, line 9

On Friday August 22, 2008 06:07:11 QrA said:

What these errors means? Is there everything ok?

Greetings from Poland
QrA

On Friday August 22, 2008 06:17:37 QrA said:

Ok. It was my fold ;) wrong database name ;) now everything is ok - backup size is exactly same as manual back up. But can you explain me this log?

10 percent processed. (Severity 0, state 1, error number 3211, line 9)
20 percent processed. (Severity 0, state 1, error number 3211, line 9)
30 percent processed. (Severity 0, state 1, error number 3211, line 9)
40 percent processed. (Severity 0, state 1, error number 3211, line 9)
50 percent processed. (Severity 0, state 1, error number 3211, line 9)
60 percent processed. (Severity 0, state 1, error number 3211, line 9)
70 percent processed. (Severity 0, state 1, error number 3211, line 9)
80 percent processed. (Severity 0, state 1, error number 3211, line 9)
90 percent processed. (Severity 0, state 1, error number 3211, line 9)
Processed 48192 pages for database 'euro_anna', file 'euro_anna' on file 1. (Severity 0, state 1, error number 4035, line 9)
100 percent processed. (Severity 0, state 1, error number 3211, line 9)
Pr

On Wednesday September 17, 2008 03:20:40 srodier said:

I've gone over the installation instructions several times. I'n not sure what I'm doing wrong or why the system cannot find this procedure.

The .Net SqlClient Data Provider has received a severity 16, state 62 error number 2812
on line 1 of procedure on server FMH0772\SQLEXPRESS:
Could not find stored procedure 'expressmaint'.

Any help would be greatly appreciated.

On Wednesday September 17, 2008 04:04:06 srodier said:

To add,
XP Pro SP3
SQL 2005 Express

On Thursday September 18, 2008 12:07:56 Scott H said:

I've been able to successfully create backups from SQL 2005 Express using your tool. I have one question though. Every time I run my "Job" the job appends to the last or original file. I was hoping to create multiple individual jobs with-in a 24 hr period.
Is this possible?

Thanks for the help.

On Wednesday October 01, 2008 05:33:44 mark said:

thank you very much its a great product its simple and perfect

On Friday October 10, 2008 11:46:32 JimL said:

Is there any way to schedule jobs to run on Monday through Friday?

On Tuesday October 14, 2008 01:09:36 Don Shelman said:

Great tool; as one person stated, I'd like to have the ability to see job history. Configuration for how much history to hold of course would be prudent. And, even the ability to click on a history item and see the job output right there.

But, this is a fantastic free tool, and if you never change it again, I'll find it quite useful going forward!

Great work, and thank you!

Don

On Monday October 27, 2008 05:08:49 pcamis said:

great product!!!! thank you. next version, more default query.

On Saturday November 01, 2008 08:41:19 Edith said:

http://flonase.zipace.cn http://hipaa.zipace.cn http://oruvail.zostura.cn http://antibiotics.zenavo.cn http://medication-10-452.zostura.cn http://promethazine-254.zuvexry.cn http://weight-loss-10.zyreloj.cn http://diane-35-437.zenavo.cn http://drug-47-686.zipace.cn http://plan-b-9.zuvexry.cn http://protein-6-664.zuvexry.cn http://psychology-6-270.zuvexry.cn http://mesalazine.zostura.cn http://aceon.zenavo.cn http://anxiety-549.zenavo.cn
http://insomnia-62.zipace.cn

On Monday November 03, 2008 11:46:37 David said:

Just installed your product and it seems very good. The backup routine works but returns all sorts of error messages.

I want to be able to execute a stored procedure every night at the same time on a specific database. Is this the correct format please?

EXECUTE [database_name].[dbo].[sp_expiration_update]

On Tuesday November 04, 2008 06:30:42 Alfred said:

http://phencyclidine.zuvexry.cn http://lysodren.zostura.cn http://zoladex.zyreloj.cn http://medication-9-266.zostura.cn http://hydrea.zipace.cn http://ortho-1-507.zostura.cn http://melphalan-726.zostura.cn http://drug-38.zipace.cn http://nursing-15-476.zostura.cn http://aldactone-149.zenavo.cn http://trazolan-455.zyreloj.cn http://ventolin.zyreloj.cn http://treatment-46-451.zyreloj.cn http://solution-29.zyreloj.cn http://wellbutrin-607.zyreloj.cn http://glucophage.zipace.cn http://gasex-808.zipace.cn http://depression-4-189.zenavo.cn http://anafranil-774.zenavo.cn http://naratriptan.zostura.cn
http://solution-26.zyreloj.cn

On Monday December 01, 2008 08:59:27 Pino said:

Ottimo prodotto. Funziona perfettamente. Non riesco invece a far funzionare il feedback email. di seguito l'errore System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: The remote name could not be resolved: 'mymailserver.com'

We want to hear what you have to say about this article!

New Comment

 
[Login]