it might not be obvious, but the query is assuming a monday thru friday work week.

so if today is monday, i want errors from Sat + Sun + so far...

SQL will do the locking for you automatically, depending on what you update;

SQL will figure out if it needs to lock a few rows, pages or even the whole table,...

ok try this:

this returns only jobs whos last status was failed.

ignore the extra variables in there, it is an artifact of a process I run that gets the fully qualified...

because of the forum, the two tags i added: < a > and < / a > must have the white space removed. with whitespace, it's not valid xml and...

sure!

here's a handful of examples.

you can use the filter to search for exact or like statements, using asterisk as the like character multiple domains,

two of the examples have the examples...

when you get really big strings like that, and want to visualize them in SSMS, you can TRY_CONVERT to xml; then when you click it , it opens in a...

• This reply was modified 4 years, 5 months ago by Lowell.

for the query below, the h.[run_status]  is what determines what was successful/failed/inprogress.

add the filter to limit it to failed only, and change the date range.

--desc: gets job...

definitely use PowerShell for this;

here are two examples I use constantly:

Get-ADGroupMember -Identity "CoolestGroup"  | Out-GridView

Get-ADUser -Filter {(Name -eq 'steve.jones')} -ResultPageSize 50 -Properties * | 
 ...

i suspect you are missing two pieces of the puzzle.

to use database mail, any non-sysadmin active directory user (or more preferably, the AD group they belong to, have to be...

the issue is most definitely that the SQL service is running as a local account, and not a domain account.

SELECT * FROM sys.[dm_server_services]

when you run any TSQL that accesses a...

• This reply was modified 4 years, 8 months ago by Lowell.

a few things to check if polybase is not able to start;

on my developer edition box, I had to make sure TCPIP connections were enabled, which is not an issue...

the stack overflow article mentions bugs in SSRS 2008R2(and maybe SSRS 2012), so the first part does not appear to apply if you are running SSRS 2014.

The second part, where...

so if you use the report, it works, but when run as the automation account, it fails, right?

sounds like permissions.

check the data source for the sub report. it should be...

• This reply was modified 4 years, 10 months ago by Lowell.
• This reply was modified 4 years, 10 months ago by Lowell.

i see your strategy, simply filter with a WHERE statement to process just the desired rows.

I suspect you just need a decent cursor model? here you go!

create...

To leverage the Alias, I think you would need to either use a common Table Expression or a sub query to expose the alias to the next statements.

Alais's are evaluated...