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 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 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 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'

On Thursday January 08, 2009 12:57:14 Jason said:

Great product. Thanks...

On Monday February 23, 2009 07:49:14 Erpod said:

Great tool, this works fine on my PC with my rights, howether, on my partneer 's PC, he got an Error

"Failed to decrypt using provider
'DataProtectionConfigurationProvider'. Error message from the
provider: Key not valid for use in specified state.
(Exception from HRESULT: 0x8009000B) (C:\training DS
Bucharest\DS-Backup\SQLSchedulerFolder\Service\jobs.config
line 9)"

Does some one has a work around?

On Saturday March 28, 2009 11:21:05 SQL 2008 Junkie said:

Any planned support for SQL Server 2008 and Windows Server 2008/Windows Vista?

On Monday April 06, 2009 04:35:26 BB said:

I needed help with the email notification. I have tried everything I can think but no luck. I have pasted what I have added below. Any help would helpful. Thanks!

<system.net>
<mailSettings>
<smtp deliveryMethod="Network" from="reporter@gmail.com">
<network host="smtp.gmail.com" username="reporter@gmail.com" password="******" />
</smtp>
</mailSettings>
</system.net>

On Monday April 27, 2009 11:42:05 Pietro said:

Great tool! Nice idea!

It would be wonderful if in the next versione you will add the following features:
- The ability to insert a defaul mail body message for each job
- The ability to send mail message just if the Sql statement has records.
- Customize the subject of the mail messages
- Send the result set of the sql statement as attachment of the mail message

THANK YOU SO MUCH FOR EVERYTHING!

On Wednesday May 13, 2009 04:45:19 molay said:

hi ,
This tool is amazing except i am not able to use email notification. i am having the error below ;
I have tested every thing but still nothing ..i am using the same information to send email form a web application from the same machine..and it worked fine..but with SQLScheduler it did not..
Any help will be greatly appreciated.
thanks


*************************************************
email notification test(13/05/2009 4:33:39 PM): Job started.
email notification test(13/05/2009 4:33:40 PM): Job finished. Status : Succeeded
email notification test(13/05/2009 4:33:40 PM): Run results :
email notification test(13/05/2009 4:33:45 PM): System.Net.Mail.SmtpException: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.1 Client was not authenticated
at System.Net.Mail.MailCommand.CheckResponse(SmtpStatusCode statusCode, String response)
at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command,

On Monday May 18, 2009 11:43:03 Hel said:

Is it a way to transfer job setting from one server to another, just for not making it manually again?

On Monday May 18, 2009 05:25:20 Graham said:

Great app guys... our problem is that we need a scheduled task to run daily every 30 mins between 10am and 2pm

Is there a way to configure your scheduler to do this?

On Thursday May 21, 2009 10:40:40 LazyCoding.com said:

Hel,

Unfortunately, the only way to do it right now is to copy over the jobs.config file and remove the encrypted section from the jobs.config file.

The passwords are being encrypted with a machine key which is computer dependant. The only way to avoid this is not to store any passwords by using Trusted Security.

On Thursday May 21, 2009 10:41:56 LazyCoding.com said:

Graham.

Setup a job to run every 30 min.

In your job script, put something like:

If (getDate() between 10am and 2pm)
begin
do something
end;

On Monday June 01, 2009 08:34:15 Rob said:

Looks like a good product...Do you have plans to update or certify this for SQL Server 2008 Express?

On Monday June 15, 2009 04:22:49 denise said:

I have this script running backups ok, what can I add to it to delete bakup files that are older than a few days? I'm having trouble with command syntax. Thanks very much for any ideas.

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

SET @BackupName = 'dbase_' + 'db_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = N'd:\denise\' + @BackupName

BACKUP DATABASE dbase to
DISK = @BackupFileName

On Tuesday June 16, 2009 11:02:47 Ken said:

I found this stored procedure that does backups, index maintenance, reporting and cleans up old backup files and reports.
Works beautifully with SQLScheduler.

http://www.sqldbatips.com/showarticle.asp?ID=27

On Thursday June 18, 2009 07:40:29 Ribbon said:

Hi
i dont manage to make it work under windows 2003 r2 sp2 or windows xp sp3
on both i have sql express 2005 sp3

the service installs well but is not able to start ( when trying to start it i have a message saying that the service could not start because he has nothing to do)
the path defined in the bat file is valid : "%SystemRoot%\Microsoft.NET\Framework\v2.0.50727"

is there something to activate in sqlexpress in order to make the service start ?

Thanks a lot for your answers

On Friday June 19, 2009 04:51:41 Ribbon said:

sorry guys,

it just was the group name in the ini file, as i am not using an english windows version

great work !

On Wednesday June 24, 2009 06:27:29 Tavioski said:

Hey Ribbon, I'd the same issue, but I don't know how to fix it, where is that ini file, you talk about. Please you, or someone else do me a favor, an explain to me how to fix this up!!! I'll appreciate all your help.

by the way great work, I ran it in a different PC with WIndows XP (English Version) and it works just great....

On Wednesday June 24, 2009 06:56:31 Tavioski said:

Hey thanks I just find the answer, in the forum about instalation, http://www.lazycoding.com/articles/installation_questions_18.aspx,


On Wednesday April 25, 2007 02:03:53 LazyCoding.com said:

Igor,

Please open the SQLScheduler.WindowsService.exe.config file with notepad and make sure that the 'authorizedGroup' attribute
points to valid group name in your localized version of Windows.

.. channel ref="ipc" portName="SQLSchedulerServerPipe" ...

... authorizedGroup="everyone" ...

In your case, replace "everyone" with a Russian version of this group name.


Thanks anyway

On Thursday July 02, 2009 04:03:03 Stephane said:

Congratulations, great tool

Some usefull ideas to improve SQLScheduler:
- The ability to send emails notification to a group of users (instead of repeating users emails for each job)
- The ability to group jobs by categories
- Jobs history, not only the last runnning results

Thanks

On Wednesday July 22, 2009 06:29:31 amanjeet said:

Recieved following error while excuting the job.

moneyfrobackup(7/22/2009 3:46:42 PM): Job started.
moneyfrobackup(7/22/2009 3:46:47 PM): Job finished. Status : Failed
moneyfrobackup(7/22/2009 3:46:47 PM): Run results : The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3201
on line 7 of procedure on server mssql.moneyfrommobile.in:
Cannot open backup device 'D:\backups\moneyfro_20090722.bak'. Operating system error 3(The system cannot find the path specified.).
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3013
on line 7 of procedure on server mssql.moneyfrommobile.in:
BACKUP DATABASE is terminating abnormally.

On Thursday August 06, 2009 10:01:32 Tony King said:

Great work, saved me so much time! I now have an efficient unmaned backup system to a raid-1 network drive of our critical data.

You can also add 64 bit Vista to your list of supported OS's... it's running very smoothly on it.

On Thursday August 06, 2009 10:05:18 Tony King said:

@amanjeet - Your error is pretty simple, it's either an invalid path to your backup folder, or a permissions issue.

On Wednesday September 09, 2009 10:06:40 LK said:

Wonderful program, it save much of our time, but how can i change the email alert subject ?

On Monday September 14, 2009 07:13:59 Stone said:

I met the mail problem as well. My mail server relay the email on port:587, I got the following error. Could you please help me out?


System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: The remote name could not be resolved: 'myMailServer:587'
at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6, Int32 timeout)
at System.Net.PooledStream.Activate(Object owningObject, Boolean async, Int32 timeout, GeneralAsyncDelegate asyncCallback)
at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback)
at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout)
at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port)
at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port)
at

On Monday September 14, 2009 07:20:30 Stone said:

I saw the previous solutions.
Now it works fine.

:)
regards

On Tuesday September 29, 2009 05:26:06 AG said:

Hi,

Tried your product, and must say for its simplicity, it works great. I do have one questions, as to how to overwrite backups, rather then append. My backup files keep increasing really fast. for eg, if i back up a 100MB databse, the first back up is 100MB, but the second is 200MB, the third 300MB and so on.

Thanks

On Friday November 06, 2009 01:52:55 Diya said:

Great tool, this works fine on my PC but in another PC, got an Error

Failed to decrypt using provider
'DataProtectionConfigurationProvider'. Error message from the
provider: Key not valid for use in specified state.
(Exception from HRESULT: 0x8009000B) (C:\training DS
Bucharest\DS-Backup\SQLSchedulerFolder\Service\jobs.config
line 9)

Please help me.....

On Thursday November 12, 2009 09:55:06 igor_italy said:

Hi all,
very good product and very useful for my aims. Thank you very much.

I have only a question: I have a virtual server in wich I have installed my SQL Server 2005 Express and SQLScheduler for my backup; with SQLScheduler is it possible to save the backup file not in a folder of my virtual server but in a different server, via IP for example?

I ask it to make a more reliable system, in order to have the backup file in different machine.

Thank you for your product and for the answere if it will be.

On Monday November 23, 2009 04:51:17 SQLKid said:

Great Service to the SQLExpress community with the scheduler.
But i need little more info about the scheduler if it is OK.

when i schedule a job for the first time i setup the sqlserver authentication mode and enter the user name and the password and the server name.

Say later in a month or so, if i change the login password on the sqlserver, do i need to change the password on the scheduler too? or will that automatically get the password from the sqlserver database for that login?
Currently i manually reset the password.

On Monday November 23, 2009 07:50:52 LazyCoding.com said:

SQLKid,

In the case you are describing you would need to manually re-enter the password each time it is reset. The only way around it would be setup SQLScheduler to use Trusted Security (Windows Authentication). Then you would leave the username/password fields blank, and SQLScheduler would connect to the SQL Server using the account under which the Windows Service is running.

Go to Service ->SQL Scheduler Service> Properties. Depending on your Windows configuration (workgroup or domain) this account would need to have access to your SQL Server to perform whichever task needs to be done.

Hope this helps.

-Lazycoding.com

On Monday December 14, 2009 10:34:23 Chazza said:

Downloaded and tested last week, pretty good attempt. I have several stored procedures which run every minute linking to 10 other SQL servers. Using scheduled batchfiles is clumsy. For the most part SQLScheduler did a better job except I noticed a memory leak and execution was not always reliable (whereas from batch and osql it works every time) even when timeouts were lengthened to 30 seconds or more.

On Wednesday December 23, 2009 10:45:28 Brian said:

I set it up for my system db's and all worked well. When I tried it on a user db, this is the error:

The .Net SqlClient Data Provider has received a severity 16, state 11 error number 911 on line 7 of procedure on server erappos:
Could not locate entry in sysdatabases for database 'erapstore'. No entry found with that name. Make sure that the name is entered correctly.
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3013 on line 7 of procedure on server erappos:
BACKUP DATABASE is terminating abnormally.

The erapstore db is there but.......it has a sbd extension. Apparently that is for Micosoft Accounting software. I can back this up using your script in the query window. Why won't it work thru SQLScehduler?

On Thursday December 31, 2009 01:19:59 Mark said:

Is it possible to have multiple steps in one job or do i need to make each step a seperate job and schedule them apart.
Example:

Step 1: Shrink OrderManager Database File

DBCC SHRINKFILE (OrderManager)
GO

Step 2: Shrink OrderManager Log File

DBCC SHRINKFILE(OrderManager_log,100)
GO

Step 3: Backup OrderManager Database

BACKUP DATABASE OrderManager TO DISK = 'C:\SEBackup\OrderManager.bak' with DIFFERENTIAL
GO

Step 4: Backup OrderManager Log

BACKUP LOG OrderManager TO DISK = 'C:\SEBackup\OrderManager_Log.trn'
GO

On Monday January 04, 2010 10:23:15 Brian Conner said:

Will this product work with SQL Server 2008 Express Edition?

On Tuesday January 26, 2010 09:40:46 Markus said:

just found this software today and gave it a try.
it works GREAT on SQL2005 express.
looking forward to a SQL2008 version...

On Tuesday February 16, 2010 03:09:58 Pietro said:

No news?
We all are waiting for new version :))

On Tuesday April 20, 2010 12:59:13 Forrest Essic said:

I am using your sw to execute a stored procedure every 10 seconds, but every few days it stops working. Once it stops, I find jobs.config empty. It isn't hard to fix, what could be causing it?

On Sunday April 25, 2010 07:21:37 Claude said:

Great piece of sotware.

It works OK against my SQLserver 2008 installation.

On Tuesday May 25, 2010 12:22:07 Glenn said:

Thanks for the comment re SQLServer 2008. That's good to know.

On Friday June 04, 2010 07:56:59 Don Shelman said:

Just came in this morning and found a job that's scheduled every 5 seconds to be stalled. Could have been all of it, I don't know. I had to disable/reenable the job, and it took off again. Any way to prevent that? I'm running SQL 2008 Express.

dshelman@steelcase.com

On Monday June 21, 2010 11:15:57 Jim in CT said:

Great application! Trying to run it with SQL 2008 Express and getting "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." when Executing the job. I see the .bak file created, but it disappears after 15 seconds, then I get the error.

I'm not well versed in SQL. Might be an error on my part. Any thoughts?

-Jim

On Friday June 25, 2010 10:29:59 Jim in CT said:

Nevermind. I realized I needed to extend the timeout period long enough for the backup to complete. Duh. Awesome awesom app.

On Thursday July 22, 2010 03:18:03 Marc said:

The program works great!

I think more documentation on the website is needed.
It took me a long time to figure out what syntax was needed for a simple results query.
Select * From [server].[database].[table] doesn't appear to work but Select * From [database].[table] does

Does the program have to be open to run at the scheduled time?

On Thursday July 22, 2010 03:30:50 Marc said:

The timeout period got me a few times to - simple thing to overlook

On Friday July 30, 2010 09:12:29 Aleksey said:

After installation a service not start. I have tried to start it manually - error "Service on local computer started and then stopped. Some Services Stop automatically if they have nothing to do". Windows XP SP3.
What it is possible to make?

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

New Comment

 

LazyCoding.com ©2006-2009 All rights reserved

[Login]