Thanks,

But my original question is not about how to use the tabs from advanced step about  success quit, and fail continue etc.

I know all those.

It is about the syntax on...

Do I need to declare variable like in  function or not

• This reply was modified 6 years, 4 months ago by sqlfriend.

I just wonder what is the syntax that should work in the T_SQL step.

Thanks, I know the condition and the process, but how can I construct the sql to let it know if it is 0 then on success, if 1 failure.

Could you...

Thanks, I see in advanced, I can choose go to next step...

But where it knows if the result is 0 or 1 to make decision?

Thanks

Thanks,

But how i can write code in the step like if count 0 then quite with success, if count 1 go to next step.

For containers, I feel it is more a developer thing, that makes their development platform easier ,quicker, portable. For production environment, for DBA to maintain, are we going to also...

Thanks, I would agree with both of you.

I think just master  the systems your current place using or if you want to move, master most popular systems that could be...

Yes, it is from the database weekly newsletter.

Subject: Containers Are The Present, Not the Future, Get Back to Basics, and a Brief History of Machine Learning (Database Weekly 3/30/2019)

Thanks, I found the reason is because during a week ago job run, there is a windows update reboot server that interupts the DBCC.

Got fixed

Thanks,

here is the script for the alert 014

EXEC msdb.dbo.sp_add_alert @name=N'014 - Insufficient Permissions',
        @message_id=0,
        @severity=14,
        @enabled=1,
        @delay_between_responses=0,
        @include_event_description_in=0,
        @category_name=N'[Uncategorized]',
        @job_id=N'00000000-0000-0000-0000-000000000000'
GO

Are there any scripts for the SQL agent job? I'am using 2017

Can I ask why use OLEDB provider?   I would like to catch who used the linked server and failed, and who accessed linked server data and what data is accessed....

I thought the LoginName is the windows user login.

Could you give an example what the login looks like that includes linked servername?

Thanks