Click the New Job option, then it is shows like below

Steps Tab: Now, we will define the steps. Click the New button,

 

 

 

It is having 2 options General and Advanced.  In General, we will give the execution script. That type may be in T-SQL , PowerShell, CmdExec, SSIS Package, etc.,

and Advanced option,

We may create the no. of steps

Schedule Tab:

In this Tab we will schedule the time and date as per our need. see the belows,

Notification Tab

Remaing Tabs are used based on our need.

Finally click ok button thats all the job creation. 

 

Step 1:
First Create a Function for getting Object which is using linked server

CREATE FUNCTION [dbo].[fuGetLinkedServerNameInSPs](@ServerName varchar(MAX))
RETURNS @Return TABLE (XName varchar(200),XType Varchar(3))
AS
BEGIN
;WITH cteTableValueCollection(Name,Type)
AS
(
SELECT DISTINCT o.name, o.xtype FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id WHERE c.TEXT LIKE '%' + @ServerName + '%'
)
INSERT @Return SELECT Name,Type FROM cteTableValueCollection
RETURN
END

Step 2 :

Getting Linked server Names in DB.

create table #tmpLinkedServerNames(SeqID int Identity(1,1),SRV_Name varchar(100),SRV_ProviderName varchar(50),SRV_Product varchar(50),SRV_Datasource Varchar(50),
SRV_Providerstring varchar(50),SRV_Location varchar(50),SRV_Cat varchar(50))

insert into #tmpLinkedServerNames(SRV_Name,SRV_ProviderName,SRV_Product,SRV_Datasource,SRV_Providerstring,SRV_Location,SRV_Cat) exec sp_linkedservers

select * from #tmpLinkedServerNames


Getting Whole List

Declare @MaxCount tinyint,@NextCount tinyint,@LinkedServerName Varchar(50)
Declare @spList Table(LinkedServerName Varchar(20),objectName Varchar(50),ObjectType Varchar(3))

-- Get the Linked Server Count
select @MaxCount=MAX(seqid) from #tmpLinkedServerNames

set @NextCount = 1
while(@MaxCount >= @NextCount)
begin
-- One by one process
select @LinkedServerName = SRV_Name From #tmpLinkedServerNames where SeqID = @NextCount

insert into @spList(LinkedServerName,objectName,ObjectType) select @LinkedServerName,XName,XType from [dbo].[fuGetLinkedServerNameInSPs](@LinkedServerName)

Set @NextCount = @NextCount + 1

end

Now the Table display the Entire list that is having linked server name.

select * from @spList

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace WindowsService.Function
{
    public class WriteToFile
    {
        public void WriteToFile1()
        {
            string strDateTime = DateTime.Now.ToString();
            StreamWriter sw = new StreamWriter(Path.Combine("D:\\temp\\", "Suresh.txt"), true);
            sw.WriteLine(strDateTime);

            sw.Close();
        }
    }

}

using System;
using System.ServiceProcess;
using System.Timers;
namespace TestWindowsService
{
    partial class Service1 : ServiceBase
    {   //Make the service at particular time period
        Timer TimerObj = new Timer(ConvertMinutesToMilliseconds(30));
        public Service1()
        {
            InitializeComponent();
        }
        protected override void OnStart(string[] args)
        {   // TODO: Add code here to start your service.
            TimerObj.Elapsed += new ElapsedEventHandler(OnElapsedTime);
            TimerObj.Enabled = true;
        }
        protected override void OnStop()
        {   // TODO: Add code here to perform any tear-down necessary to stop your service.
            TimerObj.Enabled = false;
        }
        protected void OnElapsedTime(object source, ElapsedEventArgs e)
        {  //Write the current datetime to the file
           WindowsService.Function.WriteToFile objWriteToFile = new WindowsService.Function.WriteToFile();
        }
        public static double ConvertMinutesToMilliseconds(double minutes)
        {
            return TimeSpan.FromMinutes(minutes).TotalMilliseconds;
        }
    }
}

Let's suppose you want to give a warning information to the clients:
<asp:GridView ID="GridView1" DataKeyNames="ID" ...>
<Columns>
<asp:TemplateField HeaderText="ButtonColumn">
<ItemTemplate>
<asp:Button ID="Button1" runat="server" CommandName="Delete" OnclientClick="<%#Eval("Primary Key","return confirm('Are you sure to delete Record {0}?');")%>"/>
</ItemTemplate>
</asp:TempalteField>
</Columns>
</asp:GridView>

Example :

<asp:ImageButton ID="imgView" ImageUrl="../Images/view.jpg" runat="server"
OnClientClick='<%# Eval("Accname", "Openpopup(\"{0}\"); return false;") %>'>
</asp:ImageButton>

Add SET NOCOUNT ON to the top of the trigger definition. This will suppress the additional rows affected message that emanates from the trigger and confuses SSMS. 
otherwise, some times its through an errror :
The row value(s) updated or delted either do not make the row  unique or they alter multiple rows

CREATE TRIGGER trgProcessHistory
ON M_Process 
AFTER UPDATE 
AS 
SET NOCOUNT ON;
IF( 
 UPDATE (Rate) OR UPDATE (LocationID) 
 OR UPDATE (LOBID) OR UPDATE (ProcessDescription) 
 OR UPDATE (System) OR UPDATE (Active) 
 OR UPDATE (CreatedBy) OR UPDATE (CreatedOn) 
 OR UPDATE (ModifiedBy) OR UPDATE (ModifiedOn)
   )
BEGIN
 INSERT INTO dbo.M_ProcessHistory(
   SeqID,LOBID,LocationID,ProcessDescription,System,Rate,Active,
   CreatedBy,CreatedOn,ModifiedBy,ModifiedOn,UpdatedOn,
   DBLoginName,ClientIP)
 
 SELECT  SeqID,LOBID,LocationID,ProcessDescription,System,Rate,Active,
   CreatedBy,CreatedOn,ModifiedBy,ModifiedOn,getdate(),
   user_name(),Host_Name()
 FROM deleted ; 
 
END;