automate a SQL query to run every month

sql-server sql-server-2005 tsql sql-server-express
12,472

For SQL Server Express, there are a few possibilities. Unfortunately none of them involve Management Studio:

  1. Use a combination of Windows Scheduler, sqlcmd.exe, and .bat files
  2. Use SQL Server Service Broker
  3. Use a Codeplex variation of SQL Agent
  4. Use SQL Scheduler (free download)
Share:
12,472

Related videos on Youtube

ItsPronounced
Author by

ItsPronounced

Constantly learning web application development. Self taught ASP.NET and php since 2003.

Updated on May 04, 2022

Comments

  • ItsPronounced
    ItsPronounced about 2 years

    I have a simple SQL query that updates some date fields in a record, on a SQL Express instance.

    I'd like to have it run automatically every month. What is the best way of accomplishing this in SQL Server 2005 Express using the Management Studio?

    • Matt
      Matt almost 14 years
      Why would you ever use a .bat when you can use a job that is built into SQL Server exactly for this purpose?

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

What does OBJECT_ID do in SQL Server?
Conversion failed when converting the varchar value '1,' to data type int
Getting Number of weeks in a Month from a Datetime Column
Global Temporary table delete operation
Select query select based on a priority
How can remove lock from table in SQL Server 2005?
SQL query in SQL SERVER 2005 - Comparing Dates
SQL Server: WHERE NOT EXISTS is not working
Find out which row caused the error
Stored proc to remove records older than N days