Re: [OT] Sql Server job owner

2020-09-30 Thread Tom P
com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Greg Low > *Sent:* Thursday, 1 O

Re: [OT] Sql Server job owner

2020-09-30 Thread Tom P
gt; > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Thursday, 1 October 2020 1:34 PM > *To:* ozDotNet > *Subject:* Re: [OT] Sql Server job owner > > > > Hey Greg > > > > The job properties in SSMS show the same thing, a tilde. &

RE: [OT] Sql Server job owner

2020-09-30 Thread Greg Low
;reserved=0> From: ozdotnet-boun...@ozdotnet.com On Behalf Of Greg Low Sent: Thursday, 1 October 2020 1:35 PM To: ozDotNet Subject: RE: [OT] Sql Server job owner Well at least the scripting works right 😊 Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61

RE: [OT] Sql Server job owner

2020-09-30 Thread Greg Low
Thursday, 1 October 2020 1:34 PM To: ozDotNet Subject: Re: [OT] Sql Server job owner Hey Greg The job properties in SSMS show the same thing, a tilde. Cheers Tom On Thu, 1 Oct 2020 at 13:19, Greg Low mailto:g...@sqldownunder.com>> wrote: Never seen that one before. If you look at the

Re: [OT] Sql Server job owner

2020-09-30 Thread Tom P
et-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Thursday, 1 October 2020 12:22 PM > *To:* ozDotNet > *Subject:* [OT] Sql Server job owner > > > > Hi all > > > > I have scirpted out a Sql Server job and the owner parameter is specified > as '~' (a tilde character). Does anyone here know what the tilde means? > > > > @owner_login_name=N'~' > > > > My googling skills have let me down. > > > Cheers > > Tom >

RE: [OT] Sql Server job owner

2020-09-30 Thread Greg Low
D&reserved=0> From: ozdotnet-boun...@ozdotnet.com On Behalf Of Tom P Sent: Thursday, 1 October 2020 12:22 PM To: ozDotNet Subject: [OT] Sql Server job owner Hi all I have scirpted out a Sql Server job and the owner parameter is specified as '~' (a tilde characte

[OT] Sql Server job owner

2020-09-30 Thread Tom P
Hi all I have scirpted out a Sql Server job and the owner parameter is specified as '~' (a tilde character). Does anyone here know what the tilde means? @owner_login_name=N'~' My googling skills have let me down. Cheers Tom