MSSQL Server Jobs

MSSQL Server jobs let you execute predefined jobs in the Microsoft SQL Server Agent to perform administrative tasks. The jobs can be Transact-SQL scripts, command prompt applications, Microsoft ActiveX scripts, Integration Services packages, Analysis Services commands and queries, or Replication tasks.

Notes:

To run these jobs, your system requires CA WA Agent for Windows and CA WA Agent for Microsoft SQL Server.
Due to a Microsoft SQL Server restriction, the agent cannot run multiple MSSQL Server jobs with the same name simultaneously. If a MSSQL Server job is running, you cannot rerun the job until its previous execution finishes.
MSSQL Server jobs do not produce a spool file.