Cron Jobs in SQL Server

Cron Jobs in SQL Server

Cron is a utility for time-based job scheduling operations.

PowerShell Scripts help us in configuration of Cron Jobs.

 

Steps to Schedule a cron job:

  1. Open the SQl Azure / Cloud Sites Control Panel.
  2. Click on the site with the database >>  Features (tab).
  3. Under Scheduled Tasks (Cron Jobs) >> Add New Task (This is similar to STEP we see in regular SQL Server Job)
  4. Name the Job >> Check  Send me an email check box
  5. Configure the step. Ex: Select http as the script language and Enter the URL to the ASP script/PowerShell Script you predefined for action and notification.
  6. Schedule the job as per your requirement.

About sqlschool

SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) is one of fastest growing organization delivering Realtime Training and Realtime Projects exclusively on Microsoft SQL Server. Our Training services include SQL DBA Online Training, MSBI Online Training, SQL DBA Classroom Training, MSBI Classroom Training and Realtime Projects. SQL School, established in February, 2008 is now, one of the best institute offering Trainings on SQL Server, SQL Database Administration (DBA) and Business Intelligence (BI) technologies. We have been working with numerous consultancies in India, US, UK and Australia. We undertake Online Trainings and Corporate Trainings on SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 (DENALI) versions. We make sure that all our sessions are very much interactive and well structured. We encourage every participant to come up with his / her own queries during & after the training sessions. We prefer practical approach rather than theoretical information to master the technical depth of the technology. We provide excellent Lab Handouts for practice, Realtime Case Studies and Projects on SQL Server Administration (SQL DBA) and Microsoft Business Intelligence (MS BI) Training courses. Free LIVE DEMOs would be provided prior to training registration. Specific DAY to DAY Course Plan will also be shared prior to training registration to ensure transparency of our Training services.