PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     Dictionary of terms
     First steps with PANTHEON
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Instructions for Ensuring Compliance of PANTHEON with SAS
    [Expand]PANTHEON Installation
    [Expand]PANTHEON System
    [Expand]PANTHEON Basics
    [Expand]PANTHEON Help
    [Expand]Materials and Goods Movements
    [Expand]Assigning Identifiers
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
    [Collapse]Archive
     [Expand]PANTHEON Editions
      Installing PANTHEON on Linux and Oracle Database
     [Expand]eDocumentation
     [Expand]eInvoice
     [Expand]Workflow
     [Expand]Backup
     [Collapse]Get.start
      [Expand]Duplicates
       Windows 7
       SQL Server
      [Expand]ODBC
       SQL Server Agent
       Windows Vista
       Slabšanje performans MS-SQL strežnika
      [Expand]Row Level Security
       MS SQL Server Installation
      [Expand]Task Scheduling
       PANTHEON System Environment
      [Expand]Hardware
       Installation types on different network configurations
      [Expand]Datalab Utilities
       Installation
       On-premises installation
       PANTHEON Cloud installation
       Ordering and setting eBusiness services
       One-user installation of PANTHEON Cloud
       Network installation of PANTHEN Cloud
       PANTHEON Client Setup Wizard
     [Expand]To-do
     [Expand]End-User License Agreement
      Introductory word
     [Expand]Referential integrity (RI)
      eExchange
      SMS notifications
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 421.4461 ms
"
   2553 | 2945 | 337041 | Updated
Label

SQL Server Agent

SQL Server Agent

SQL Server Agent

SQL Server Agent is responsible for running scheduled tasks (jobs)on the SQL Server.

SQL Server Agent also monitors other operations: replication, error logs, and startup of other processes (like e-mail).

SQL Server Agent must be running for correct functioning of the SQL Server. This is especially important if the computer running SQL Server is regularly turned off or restarted.

Starting SQL Server Agent from the Windows GUI

SQL Server Agent can be started through the SQL Server Service Manager. The Service Manager is usually started at Windows startup and can be opened by double-clicking its icon in the tray. Alternatively, navigate to the SQL Server program group in Start | All Programs, and click Service Manager.

 004834.gif

Under Server, select the desired SQL Server instance if it is not already selected.

Under Services, select SQL Server Agent if it is not already selected.

Click the Start/Continue button.

Enable the option Auto-start service when OS starts if you wan that SQL Server Agents is started automatically when Windows starts up (recommended).

 004835.gif

Starting SQL Server Agent from Command Prompt

SQL Server Agent can be started with the scm utility that can be found in the BINN folder of the SQL Server installation folder.

To start SQL Server Agent type in the following in the command prompt on the computer running SQL:

scm -action 1 -service sqlserveragent

To stop SQL Server Agent type:

scm -action 6 -service sqlserveragent

To enable auto-start of SQL Server Agent with Windows startup type:

scm -action 7 -service sqlserveragent -svcstarttype 1

Ti disable auto-start of SQL Server Agent type:

scm -action 7 -service sqlserveragent -svcstarttype 2

Starting SQL Server Agent from Services

SQL Server Agent can be started from the Services management utility. Open it by typing services.msc in the Run box or by navigating the Control Panel | Administrative Tools | Services.

Find the service SQLServerAgent, right-click on it and select Start.

 

046389.gif SQL Server Agent auto-start cannot be enabled in Windows 95/98/ME. You have to start SQL Server Agent manually each time Windows starts up.

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!