AG - Am I Primary.sql

--add as step 1 on every AAG-aware job
IF NOT EXISTS (
SELECT @@SERVERNAME, *
   FROM sys.dm_hadr_availability_replica_states  rs
   inner join sys.availability_databases_cluster dc
   on rs.group_id = dc.group_id
   WHERE is_local = 1
   and role_desc = 'PRIMARY'
   and dc.database_name = N'whateverdbname'
)
  BEGIN

	print 'local SQL instance is not primary, skipping';
	throw 50000, 'Do not continue', 1;

  END