Click here to learn how to Setup up a Network Monitor with Optitask
I appologize for all the links to my previous Optitask blog but I don’t really want to move the content to the new official blog so please bare with me. My old blog at Ernic is still active but is primarily my personal and contracting blog.
Read the full article on how to Schedule a SQL Query or Stored Procedure to execute at scheduled times.
Create a new task and add a new “SQL Task” action. Right-click on the new task, select properties and then click on the settings page.
You need to specify a database connection to use, if you don’t have one use the data source manager to create a new connection to the database server.
To perform the backup enter the following SQL command:This will perform a backup of the “Northwind” database and create the output database to ‘C:\NorthwindSQLBackup.bak’.
BACKUP DATABASE Northwind TO DISK = 'C:\NorthwindSQLBackup.bak'
One additional setting you will need is the Command Timeout. In this example I’ve set the timeout to 3600 seconds (1 hour), otherwise the command will timeout before the SQL backup is completed.
I wrote an article a while back on my personal blog about: “How to send a SMS message or Email automatically when SharePoint list is updated. This is very handy when you need to notify users when a document was added or updated in a document library amongst other things.
Here’s the link to the article explaining the steps involved:
Automatically send SMS messages when a Sharepoint List is updated
Developers and IT administrators are often faced with the task to schedule a program, a stored procedure or a component perform cleanup operations, batch processing and other tasks that need to happen on a scheduled basis.
The quick and easy way out is to schedule it on your database software if it supports it or to run it from the Windows Scheduler. The problem with this is that when the job fails you have no control or knowledge of it or if an existing program is running, there is no way to prevent new instances from starting up.
With Optitask is simple to schedule anything from stored procedures, programs or even custom build .NET, COM or DLL components to execute at scheduled times and have full control.
Watch the demonstration video below to see how easy it is to schedule and execute:
- A method call on a custom build .NET component
- A custom build program
- A stored procedure on a database
There’s something about Optitask that excites me every time I fire it up. I am not sure what it is but this product makes me feel fulfilled. Could it be because I built it, or perhaps because it reminds me of my childhood playing with LEGO? Similar to LEGO, Optitask is a platform with hundreds of different actions or pieces of LEGO that fit together, and, placed in the right order can achieve great things!
Hello and welcome to the first post of our company blog. I am very excited to start this blog and hope to post regularly news about Optitask plus tutorials on how to use Optitask in your workplace. If you have any suggestions on the type of content you expect here, drop me an email at erhard@ernicsoftware.com.