Category: LazyCoding.com - SQLScheduler Posted On: March 15, 2007
I installed the service and ran executed a job. When trying to execute it was looking to place a .log file in c:\SQLSched2\Service\Logs. The zip package did not create that folder, I manually created it and all is well.
Some problem here.. v0.2.0.0 Create a folder called "Logs" in the Service folder and it works great!
WinZip omits empty folders by default, so the Logs directory did not get included into the package. Sorry for the trouble, it is now fixed. -LazyCoding.com
Hi, Great product. However I have a syntax problem with the SQL statement. This is what I have coded.... DECLARE @BackupName VARCHAR(255) DECLARE @BackupFileName VARCHAR(255) SET @BackupName = 'insitetimandnaomi_' + convert(nvarchar(20), getdate(), 112) + N'.bak' SET @BackupFileName = N'd:\virtualservers\databases\' + @BackupName BACKUP DATABASE insite-timandnaomi TO DISK = @BackupFileName WITH NOFORMAT, NOINIT, NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10 The syntax error displays this.... "Incorrect syntax near '-'. Incorrect syntax near the keyword 'with'." Any Ideas?
Ok - Have solved this by renaming the DB without the hyphen. I have also changed the backup syntax to show "WITH FORMAT" Will this type of backup be a full backup?
Hi John, 1) I haven't tried this but using brackets should've solved the dash problem you were having before. BACKUP DATABASE [insite-timandnaomi] TO ... 2) The FORMAT | NOFORMAT options are typically only used when backing up onto tapes, or when you are stripping backup accross mulitiple data files. In either case, a complete backup will be performed unless you specify the DIFFERENTIAL option.
I'm getting "System.BadImageFormatException: The format of the file 'SQLSchedular.WindowsService.exe' is invalid" when I try to run 'installservice.bat'. Any ideas ?
Hi Myles, Do you have .NET Framework 2 installed? Please make sure that "installservice.bat" runs the "installutil.exe" file from the .NET Framework 2.0 folder and not any other older versions.
.NET Framework 2 is installed but it was using an older version of installutil.exe. Thanks
Hi, Installed your product which worked fine untill the service gets started. I get a system error 1067 (and SQLScheduler Service-Service can't be started, process ended unexpectedly) Any ideas what went wrong? Thanks in advance, Dick
Hi Dick, Please take a look for any errors in the Applicatoin/System event logs. There should be an event record with more information. Thanks
Hi, I checked but there's no additional info in the eventlog record. Thanks anyway, Dick
Installed your product which worked fine untill the service gets started. I get a system error 1067 (and SQLScheduler Service-Service can't be started, process ended unexpectedly) Error in the Applicatoin/System event logs: EventType clr20r3, P1 sqlscheduler.windowsservice.exe, P2 0.2.0.0, P3 45dd34e7, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 51e4, P8 61, P9 n51cffzwz1gffvslvrub5uxq1gvd0txu, P10 NIL. I have Windows2000 SP4 (Russian Version)
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.
Thank you for help me In SQLScheduler.WindowsService.exe.config file it happened to indicate code page <?xml version="1.0" encoding="WINDOWS-1251" ?>
Installed the product yesterday and very impressed. Yoday, however I went to add a new job and I just get - SQLScheduler.GenericException: There appears to be a problem with the connection to the SQLScheduler Service. Please make that the service is up and running. ---> System.Runtime.Remoting.RemotingException: Failed to connect to an IPC Port: The system cannot find the file specified. Any Ideas?
Hi Phil, Please check that the SQLScheduler Windows service has been started on the machine where you are running the SQL Scheduler.
All sorted thanks - Someone had restarted my server without telling me.......... heads will roll....!
I get this error when i execute the scheduler job i just created. The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3201 on line 1 of procedure on server TPAPP03\SQLExpress,1642: Cannot open backup device 'F:\Bakups\CH_LibertyIMS.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 1 of procedure on server TPAPP03\SQLExpress,1642: BACKUP DATABASE is terminating abnormally. ------------------------------------------------ I get the same error when I run it from management studios. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'F:\Bakups\CH_LibertyIMS.bak'. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.
Arti, Make sure that path is valid, and check the security permissions on the folder you are trying to backup to. Make sure the service account (Network Service) has write permissions. It may well not do.
As suggested "Please check that the SQLScheduler Windows service has been started on the machine where you are running the SQL Scheduler.". I did that and I get the info that "Service got started and stopped as there was no work to do".How can this be sorted?
It appears that the cyphervalue in the jobs.config file is different based on what computer it is installed on. Is there a way to get around that so that we can use a general jobs.config file to distribute among different computers so we don't have to create the jobs manually each time we deploy your program? Thanks in advance.
When it tries to backup my 160MB database automatically, it says "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.". I suspect that is a problem associated with the timeout of the Command object.
Alessandro, Just increase the Timeout value for the job, it's on the job's properties screen.
Getting this erro in log file when executing: Fusion DB full backup(11/20/2007 11:49:23 AM): Job started. Fusion DB full backup(11/20/2007 11:49:23 AM): Job finished. Status : Failed Fusion DB full backup(11/20/2007 11:49:23 AM): Run results : The .Net SqlClient Data Provider has received a severity 15, state 1 error number 102 on line 9 of procedure on server everest: Incorrect syntax near '='. Here is details of the job backing up to local disk. I have tried removing "SKIP, REWIND, NOUNLOAD, STATS = 10" but get same error: DECLARE @BackupName VARCHAR(255) DECLARE @BackupFileName VARCHAR(255) SET @BackupName = 'Fusion_' + convert(nvarchar(20), getdate(), 112) + N'.bak' SET @BackupFileName = N'e:\acct\backups\' + @BackupName BACKUP DATABASE Fusion TO DISK = @BackupFileName NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10
Gene, I suspect you are missing a comma after DISK=@BackupFileName: BACKUP DATABASE Fusion TO DISK = @BackupFileName, NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10
Added the comma after@BackupFileName and now get this error: Fusion DB full backup(11/20/2007 8:47:39 PM): Job started. Fusion DB full backup(11/20/2007 8:47:39 PM): Job finished. Status : Failed Fusion DB full backup(11/20/2007 8:47:39 PM): Run results : The .Net SqlClient Data Provider has received a severity 15, state 1 error number 155 on line 9 of procedure on server everest: 'NAME' is not a recognized Device Type option.
Made these changes and now no syntax errors. DECLARE @BackupName VARCHAR(255) DECLARE @BackupFileName VARCHAR(255) SET @BackupName = 'Fusion_' + convert(nvarchar(20), getdate(), 112) + N'.bak' SET @BackupFileName = N'e:\acct\backups\' + @BackupName BACKUP DATABASE Fusion TO DISK = @BackupFileName WITH NOFORMAT, NOINIT, NAME = @BackupName But I now get several invalid column name errors during backup. It does run but appends to last backup. Would like to resolve errors and have backup delete previous one or just create a new one. The last few lines are: The .Net SqlClient Data Provider has received a severity 16, state 1 error number 207 on line 7 of procedure on server everest: Invalid column name 'is_present'. The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3009 on line 7 of procedure on server everest: Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with
Gene, check that your MSDB is not full. Either the database itself or the transaction log.
Great product! My only complication is that I cannot get the e-mail notification function to work. I have updated the information as stated below: <smtp deliveryMethod="Network" from="sqlscheduler@omd.com"> <network host="130.0.1.1" userName="" password="" /> </smtp> Can you help?
Mike, Check the SQLScheduler log files for errors. Also make sure that the mail server accepts relaying from the machine that is running SQLScheduler, otherwise, you might need to specify a valid account name and password.
Great Product, so first of all I thank you very much. I got it set up and running smoothly, however I have a question about the size of .bak file the program backs up. In my case the .bak file is 112 MB while if full backup done manually within SQL EXPRESS weighs 27 MB. And also, if I compress 112 MB .bak file using winrar it goes down to 8 MB. So my question is this: can we add a line to the SQL Template to compress and minimize the size of the backup following the backup job? Because this will be a great help for people like me who is also uploading the backup file using FTP to a remote server every night. Thanks again
Tolga, Take a look at the http://www.lazycoding.com/articles/sql_scheduler_feedback_19.aspx article. In one of the comments I explain how to compress the back up file with Winrar. Also the backup file created by SQLScheduler should be pretty much exactly the same as the one done by the Management Studio. The file size difference may depend on a number of settings: Transaction Log backup, complete vs differential, one backup per file vs appending backups, etc. In the end SQLScheduler only executes the command that given to it, which means that the SQL Management Studio must be running a slightly different SQL Script. Cheers and Merry X-mas
Got it! Thanks again. Happy Holidays...
Hello again; I have read and modified my code as you see below in order to compress my database backup using winrar. Everything goes through smoothly, backup is completed with no errors and I receive the email of backup succession. However, The WINRAR backup section of the code does not execute, because right after I go and check the \ZIPPEDBACKUPS\ folder where I expect the backup should be, and the folder is empty. Could you please help me to resolve this issue? Briefly, my final goal is to have my daily databse backups compressed by winRAR in my ZIPPEDBACKUPS folder, because then I will schedule FTP uploads of these compressed backups every night to my FTP server. Note: my server settings cmdshell is ENABLED by the way, and my entire syntax checks out and backup is a success everytime. ______________ SQL Template I am using within SQL Scheduler Program___________________ DECLARE @BackupName VARCHAR(100) DECLARE @BackupFileName VARCHAR(100) DECLARE @BackupPath VARCHA
.... continues from above ______________ SQL Template I am using within SQL Scheduler Program___________________ DECLARE @BackupName VARCHAR(100) DECLARE @BackupFileName VARCHAR(100) DECLARE @BackupPath VARCHAR(1000) SET @BackupName = 'ATR30DB_' + convert(nvarchar(20), getdate(), 112) SET @BackupFileName = @BackupName + N'.bak' SET @BackupPath = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\' + @BackupFileName BACKUP DATABASE ATR30DB TO DISK = @BackupPath WITH NOFORMAT, NOINIT, DIFFERENTIAL, NAME = @BackupFileName, SKIP, REWIND, NOUNLOAD, STATS = 10 DECLARE @ArchiveName VARCHAR(1000) Set @ArchiveName = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\archive.bat' + @BackupName exec xp_cmdshell @ArchiveName
continues from above.... ______________archive.bat File Content As Follows Below ____________ C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ZIPPEDBACKUPS "C:\Program Files\WinRAR\rar.exe" a -df -rr1 %1 %1.bak _________________________________________________________
Tolga, Looks like your batch file is a bit off. First, I would actually recommend to create a directory somewhere in the root of the drive called "backups" and put all the files there, instead of using the default ...Program Files\... path. It just makes things easier and cleaner, and you don't need to worry about quotes if there is a space inside a filename. So based on the example above, your batch file should be something like this: ____________________ cd "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ZIPPEDBACKUPS" "C:\Program Files\WinRAR\rar.exe" a -df -rr1 %1 ..\Backup\%1.bak ___________________
Thank you very much once more and I wish you a happy new year!... Cheers :-)
Hi, when I check my sql request, this message appears, could you help me to solve it ? Regards System.Data.DataException: 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) ---> System.Data.SqlClient.SqlException: 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)
ZeMotard, Check the server name, ip address, instrance name of the SQL Server you are connecting too. And if SQL Server is on a different machine than SQLScheduler, make sure that SQL Server can be accessed remotely.
It's an the same machine. IP / database name are ok ....
It's working, it was a bad name server .... Regards
I am getting an error error when checking the syntax 'The tpye initalizer for "System.Data.SqlClient.SqlConnection' threw an exception. When I Execute the job I get the error "System.NullReferenceException: Object reference not set to an instance of an object. at SQLScheduler.Services.JobService.WorkerCompleted(BaseWorker p_objWorker)" in the last line of the logs. Thanks.
Hello, Let me start by saying that your software is fantastic, fits my exact needs perfectly glad to see that there is still some good freeware for windows still. I only have one issue it seems to be small but when I backup one of my databases I get this error: Sutie Backup(5/27/2008 1:29:34 PM): Job started. Sutie Backup(5/27/2008 1:29:51 PM): Job finished. Status : Succeeded Sutie Backup(5/27/2008 1:29:51 PM): Run results : 10 percent backed up. (Severity 0, state 1, error number 3211, line 7) 20 percent backed up. (Severity 0, state 1, error number 3211, line 7) 30 percent backed up. (Severity 0, state 1, error number 3211, line 7) 40 percent backed up. (Severity 0, state 1, error number 3211, line 7) 50 percent backed up. (Severity 0, state 1, error number 3211, line 7) 60 percent backed up. (Severity 0, state 1, error number 3211, line 7) 70 percent backed up. (Severity 0, state 1, error number 3211, line 7) 80 percent backed up. (Severity 0, state 1, error number
Michael, These are just informational messages/warnings.
C:\Documents and Settings\Administrator\Desktop\SQLScheduler_LatestVersion\Servi ce>installservice.bat Installing WindowsService... --------------------------------------------------- 'InstallUtil' is not recognized as an internal or external command, operable program or batch file. --------------------------------------------------- Starting... Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. this is what i am getting when i run the installservice.bat file. i have .net framework 2.0 installed and verified the folder it's looking for......
Hi Chris, Just open up the installation batch file and replace the path to installUtil.exe with the valid path on your machine. It should be in the Windows directory under Microsoft.Net folder.
Been looking for something like this for ages!! But I have had a few problems and would love some help please. Installation fine, restarted service no problem. I have more than 1 database running under the MSDE instance, can I narrow in on backing up just one? I have set the following job details: DECLARE @BackupName VARCHAR(255) DECLARE @BackupFileName VARCHAR(255) SET @BackupName = connx_' + convert(nvarchar(20), getdate(), 112) + N'.bak' SET @BackupFileName = N'D:\ConnX_Backup\' + @BackupName BACKUP DATABASE connx TO DISK = @BackupFileName WITH NOFORMAT, NOINIT, NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10 However I get the following error bfore I can even save the job: SQLScheduler.GenericException: Job 'ConnX' does not exist for server 'SERVER-04\MERIDIEN'. Server stack trace: at SQLScheduler.Services.JobService.GetJobConfig(String serverName, String jobName) at SQLScheduler.Services.JobService.CheckSQLSyntax(String serverNam
Oops it doesnt all fit! Error I get it: SQLScheduler.GenericException: Job 'ConnX' does not exist for server 'SERVER-04\MERIDIEN'. Server stack trace: at SQLScheduler.Services.JobService.GetJobConfig(String serverName, String jobName) at SQLScheduler.Services.JobService.CheckSQLSyntax(String serverName, String jobName, String script) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessa
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?
I am unable to install the SQL Express edition on P3 machine... I got following error - "error 1603 installing microsoft sql server 2005 setup support file" Any Idea how do i overcome this error?
I tried to sutup a job and go the following error: Failed to decrypt using provider 'DataProtectionConfigurationProvider'. Error message from the provider: Key not valid for use in specified state. [Exception from HRESULT: 0x8009000B] [D:\SQLScheduler_LatestVersion\Service\jobs.config line Any ideas?
I just wanted to say thank you so much for providing this great tool. It has been an excellent replacement for SQL Server Agent. I hope you will consider making it an open source project and hosting it on SourceForge.net or CodeProject.com so that it will continue to evolve. Thanks and keep up the great work.
SET @BackupFileName = N'D:\ConnX_Backup\' + @BackupName whould you make skript if Backup File in another Computer Ex: \\Andhi\Backup\
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3007 on line 7 of procedure on server 192.168.1.250: 파일 또는 파일 그룹 "iView"은(는) 온라인 상태가 아니므로 백업할 수 없습니다. FILEGROUP 또는 FILE 절을 사용하여 선택 항목에 온라인 데이터만 포함되도록 제한하여 BACKUP을 수행할 수 있습니다. The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3013 on line 7 of procedure on server 192.168.1.250: BACKUP DATABASE이(가) 비정상적으로 종료됩니다.
Hi Lazycoding.com. Thank you very much for creating this simple yet absolutely necessary software. As a small company with limited IT budget, it's ppl like you that enables us to compete with the big boys and as a result offer choices to consumers. God bless you!
hi I have downloaded the product for SQL Express 2005 but i find it doesnt seem to work. the program want you to create the job in Express prior to setting up a schedule. Whats the point of that. It would be most helpful if someone could explain how one can create a job via the scheuler as this isnt possible vi aexpress.
Thanks for a great little utility. It's amazing how handy it is. I'm getting the same informational messages Michael reported. I understand these are just informational messages, but they are making the Scheduled backup trigger the "Failed" message for notifying me with an email. ...Is there a way to turn those informational messages off, or reset and provide an error code in the SQL to make SQL Schedular see it as a success if it completes? Sutie Backup(5/27/2008 1:29:34 PM): Job started. Sutie Backup(5/27/2008 1:29:51 PM): Job finished. Status : Succeeded Sutie Backup(5/27/2008 1:29:51 PM): Run results : 10 percent backed up. (Severity 0, state 1, error number 3211, line 7) 20 percent backed up. (Severity 0, state 1, error number 3211, line 7) 30 percent backed up. (Severity 0, state 1, error number 3211, line 7) 40 percent backed up. (Severity 0, state 1, error number 3211, line 7)
Thank you for use your component, i'm testing it now and works great! My goal is to have each day one backup file. So i changed your default code to this: SET @BackupName = 'fileprefix_weekday_' + CAST(datepart(weekday,getdate()) AS nvarchar(20)) + N'.bak' DISK = @BackupFileName WITH NOFORMAT, INIT, NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10 Means i will have 7 files: fileprefix_weekday_1 fileprefix_weekday_2 fileprefix_weekday_3 etc and when it's again weekday 1 the file will be override. So far so good :) But but.... I wish there was a way to make this more flexibel, so I can give the maximum number of saved files? Kind regards Marco The Netherlands
Thank you for your time and efforts. I see that some of my questions have already been answered but I do have two questions. 1) When I do the backup and it says successful, I look at the c:\backup directory and the size of my backup is 0 KB. 2) For emailing myself, do I need a userid and a password from the network host?
i have same with ur article mr.john
I installed the service and ran executed a job. When trying to execute it was looking to place a .log file in c:\SQLSched2\Service\Logs. The zip package did not create that folder, I manually created it and all is well. thanks & regards 9867953801
Very special thanx for this great and smart tool. I was installing it the described problem with the logfile has not occured. But it was required to set a valid group name and a valid servername. REGARDS Randolf Balasus
I have installed SQL Scheduler and setup the smtp settings - all looks okay, except when I run the backup script, I get the following error: The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3201 on line 7 of procedure on server server-sql.com: Cannot open backup device 'c:\dbbackup\241073_2a20090212.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 server-sql.com: BACKUP DATABASE is terminating abnormally. I have assigned write and modify permissions to the c:\dbbackup folder for NETWORK SERVICE user. I am trying to backup a remote database to my local PC running Vista Business. I have confirmed that 'c:\dbbackup' exists. Is there anything I have missed? Thanks.
Can you please tell-me where do i change the hour of the backup, i do a daily backup and by default is 0:00 ... where can i change that to another hour ? Thanks in advance
Is it possible for anyone to put a detailed explanation of what all things needs to be done for making the SQL Scheduler as working.
Anyone, has any idea of what is the below error line means??? "The .Net SqlClient Data Provider has received a severity 16, state 1 error number 8134" thanks.
This is GREAT tool, I love it, I have been using it on my local machine now for a couple of months with no problems at all. I do want to know if the scheduler will work on a 64 bit Windows 2008 Server? I would sooner find out now then install it and have problems on the server
Up until a few weeks ago, everything was fine, now I get this email error: Backup Aperio database(4/6/2009 12:00:04 AM): System.Net.Mail.SmtpException: Mailbox unavailable. The server response was: Too many invalid recipients at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message) at SQLScheduler.Static.SendNotificationEmail(String[] to, String subject, String body) at SQLScheduler.Services.JobService.NotifyOperators(JobConfigElement jobConfig, String additionalData) I can't seem to find out what is wrong. It works when I run the job dynamically but not when it is scheduled. at SQLScheduler.Services.JobService.WorkerCompleted(BaseWorker p_objWorker)
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! &lt;system.net&gt; &lt;mailSettings&gt; &lt;smtp deliveryMethod=&quot;Network&quot; from=&quot;STR@gmail.com&quot;&gt; &lt;network host=&quot;smtp.google.com&quot; username=&quot;STR@gmail.com&quot; password=&quot;*******&quot; Port=&quot;25&quot;/&gt; &lt;/smtp&gt; &lt;/mailSettings&gt; &lt;/system.net&gt;
I have a successful backup but I got this error. Backup(4/27/2009 11:11:39 AM): System.Net.Mail.SmtpException: Failure sending mail. ---&gt; System.NullReferenceException: Object reference not set to an instance of an object. at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message) --- End of inner exception stack trace --- at System.Net.Mail.SmtpClient.Send(MailMessage message) at SQLScheduler.Static.SendNotificationEmail(String[] to, String subject, String body) at SQLScheduler.Services.JobService.NotifyOperators(JobConfigElement jobConfig, String additionalData) at SQLScheduler.Services.JobService.WorkerCompleted(BaseWorker p_objWorker) I followed the installation and the config configuration in the SQLScheduler.WindowsService.exe.config. Did I miss
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,
molay, Your mail server requires to have authenticated SMTP connections. They are two ways to accomplish this: 1) Setup SQLScheduler service to run under a specific account (ether a domain account or a local account, which credentials are valid for your mail server) 2) Specify mail credentials(username/password) in the SQLScheduler.WindowsService config file.
Hello, We get email notifications for each and every job that runs even though we have now unclicked both 'Notify on Failure' and 'Notify on Success' options. We just left the email address there and we continue to get emails. What else could be triggering these emails please? Thanks, Mike
Ola, eu nao consigo executar o servi&#231;o ele me volta esse erro: O servi&#231;o SqlScheduler Service em computador local foi iniciado e interrompido. Alguns servi&#231;os s&#227;o interrompidos quando nao tem o que fazer, como o servi&#231;o de logs e alertas de desempenho. o que posso fazer?
Hi, i've decided to put it in english too..we never know... i can't execute the service...it returns this error to me: The service SqlSchedule Service in local computer was started and stopped. Some services are stopped when they don't have what to do, like log service em alert, performance service. when i start SqlSchedule i gives me this error: &quot;There appears to be a problem with your connection to the SqlSchedule Service. please make that the service is up and running&quot;. what can i do?
Got this error msg. on executing job. moneyfrobackup(7/22/2009 4:06:58 PM): Job started. moneyfrobackup(7/22/2009 4:07:00 PM): Job finished. Status : Failed moneyfrobackup(7/22/2009 4:07:00 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 'C:\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.
I provided write permisions to (network Service) also but got the same error code.
Hello, This script generates an error that indicates that the output file cannot be created. Can you tell what is wrong with the filename? I can send it to a local drive ('e:\SqlBackup' )with no problem. DECLARE @BackupName VARCHAR(255) DECLARE @BackupFileName VARCHAR(255) SET @BackupName = 'ServoxGT_' + convert(nvarchar(20), getdate(), 112) + N'.bak' SET @BackupFileName = N'\\eva-director\Sauvegarde SQl\Sqlservox\' + @BackupName BACKUP DATABASE ServoxGT TO DISK = @BackupFileName WITH NOFORMAT, NOINIT, NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10 Thanks,
I just sent email and then received from unkown sender ----The following addresses had delivery problems --- 5.7.1 Client was not authenticated Message-ID: &lt;344faec70911210504y5c26e33cy7918793b1a8231f2@mail.gmail.com&gt; Content-Type: multipart/alternative; boundary=00151773eaa09afa5b0478e13cc3 X-NAI-Spam-Report: 2 Rules triggered * 0 -- HTML_00_10 -- BODY: Message is 0% to 10% HTML * 0 -- RV3411 -- BODY: Version number Is my email delivery problems because my email was reported as SPAM by recipients email?
Hi, I know very little about prgramming, however i have followed all your instructions but when i click on execute.....nothing happens.....please help
Hi me again.....I have found the error logs and enclose a copy of them..... Daily Backup(28/02/2010 15:31:18): Job started. Daily Backup(28/02/2010 15:31:34): Job finished. Status : Failed Daily Backup(28/02/2010 15:31:34): Run results : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Hi, Is there a way to backup the jobs in SQLScheduler please? Thanks, Michael
I've successfully created a job that simply execute a stored procedure of mine. I've scheduled this job to be executed every 1 minutes, but it executes only the firts time regardless of the LastRunStatus. I notice that the &quot;NextRun Time&quot; indicated the time of the lastrun... this is the .xml of the job: &lt;jobs&gt; &lt;add id=&quot;C347D69BF6A04954B9B3C431CD4C2E95&quot; name=&quot;TEST&quot; description=&quot;Job di test&quot; lastrunresults=&quot;&quot; script=&quot;EXEC BAR.dbo.spu_SyncroLinkedServer_New @SERVER='pc-andrea2'&quot; trustedsecurity=&quot;false&quot; username=&quot;nemesy&quot; database=&quot;&quot; startdate=&quot;03/08/2010 16:25:03&quot; nextruntime=&quot;03/09/2010 14:22:00&quot; enddate=&quot;3000-03-09&quot; lastruntime=&quot;03/09/2010 12:56:00&quot; scheduletype=&quot;
Test
Hi , I have the same problem with the email notification , i cannot get it to work..i have even tried adding the port number but still nothing..what can be wrong ?? &lt;mailSettings&gt; &lt;smtp deliveryMethod=&quot;Network&quot; from=&quot;sqlscheduler@somedomain.com&quot;&gt; &lt;network host=&quot;smtp.gmail.com&quot; userName=&quot;josjorge@gmail.com&quot; password=&quot;*****&quot; /&gt; &lt;/smtp&gt; &lt;/mailSettings&gt;
Hi Please make this application compatiable with SQL 2008 Express also Thanks
i have Problem here. when i click &quot;check Syntax&quot; the error message appear &quot;Job 'truncate of database InfoValley' does not exist for server 'SYSRQ' &quot; what can i do? Thanks..
Anyone know how to program the email portion to use TLS (via Gmail)?
Anyone got some code to backup transaction logs, and clear the history within the database log file? By the way a great application all round.
Your Name
Comment
LazyCoding.com ©2006-2009 All rights reserved