Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Create Proc dbo.ACNExpire AS Declare @ACN as Varchar(10),@DtExpire as dateTime,@RecruitName as varchar(60),@RSID as integer, @NCOIDSid as Integer, @RecruiterEmail as varchar(100), @NCOEmail as varchar(100) Select * from OPENQUERY(SIDPERS, 'Select ACN, RSID, NCOID, to_char(DT_EXPIRE, ''YYYY/MM/DD'') DT_EXPIRE, APP_NAME from ACN.ACN_CNTL_NBR_TBL where (decode(to_char(sysdate,''D''),4,next_day(sysdate,''MON'') ,5,next_day(sysdate,''TUE''),6,next_day(sysdate,''TUE''),7, next_day(sysdate,''TUE''),sysdate+2)) > DT_EXPIRE and sysdate < DT_EXPIRE') Select strEmail from WorsDotNet.dbo.tblUser where intID = (Select intRecruiterId from RecruitDotNet.dbo.tblRecruiter where intRecruiterRecordId = 98)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.