title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
View a Job |
View a Job |
markingmyname |
maghan |
01/19/2017 |
sql |
ssms |
how-to |
|
= azuresqldb-mi-current || >= sql-server-2016 |
[!INCLUDE SQL Server SQL MI]
Important
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.
This topic describes how to view [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent jobs in [!INCLUDEssnoversion] by using SQL Server Management Studio or [!INCLUDEtsql].
You can only view jobs that you own, unless you are a member of the sysadmin fixed server role. Members of this role can view all jobs. For detailed information, see Implement SQL Server Agent Security.
-
In Object Explorer, connect to an instance of the [!INCLUDEssDEnoversion], and then expand that instance.
-
Expand SQL Server Agent, and then expand Jobs.
-
Right-click a job, and then click Properties.
-
In Object Explorer, connect to an instance of [!INCLUDEssDE].
-
On the Standard bar, click New Query.
-
Copy and paste the following example into the query window and click Execute.
-- lists all aspects of the information for the job NightlyBackups. USE msdb ; GO EXEC dbo.sp_help_job @job_name = N'NightlyBackups', @job_aspect = N'ALL' ; GO
To view a job
Use the Job class by using a programming language that you choose, such as Visual Basic, Visual C#, or PowerShell. For more information, see SQL Server Management Objects (SMO).