Tuesday, November 13, 2012

jobs

In looking at the Object Explorer in Microsoft SQL Server Management Studio, I see that below a server are six "folders" for:

  1. Databases
  2. Security
  3. Server Objects
  4. Replication
  5. Management
  6. SQL Server Agent

I spend all of my time in "Databases" but this suggests that SQL Server Agent is where the jobs are kept. ...And, in taking a look, it seems to be so. Right-clicking on a job and picking "Properties" reveals...

  1. General
  2. Steps
  3. Schedules
  4. Alerts
  5. Notifications
  6. Targets

General will have a checkbox for if the job is enabled while Steps will denote which sprocs are called and Notifications will tell you who is flagged by email when the job runs. Jobs are how one runs stored procedures on a timer (what might have been called a cron job in FreeBSD once upon a time). Windows Task Scheduler in contrast is used for running console apps written in ASP.NET on a timer.

No comments:

Post a Comment