Thanks

Thank you.

Yes, for the last step on success action: quit the job reporting failure.

The both steps are just T-SQL steps. There are no cmdexe

I am attaching the image of job history below.

On the success action: Go to the next step

On Failure action: Quit the job reporting failure

I can see the each job step...

Even the db backup is including the servername

Yes. I can see that. It created a folder with instance name and sub folders with each db name.

I gave path C:\backup and when I ran the job it...

This DB is very active all the time.

If it is informational message then I have to see this message frequently because checkpoint occurs every 1 min, but I...

I can see our configured value for "Recovery interval" = 0. i.e. I am thinking the checkpoint occurs by default 1 min.

We don't have traceflag enabled

There is no PID with that no.

Is there any possibility that should be a deadlock

Yes,

I can see take offline option under cluster core resources.

So restarting means taking that offline and bring that back online

Hi,

We are using Windows 2012 & Sql Server 2014.

I can see only failovercluster manager but not able to find the Cluster administrator.

Is both are same?

We have another environment which is also cluster environment.

But I can see SQL agent restart, stop. I use the restarted the agent from SSMS instead of cluster manger. Is it...

Your option importing from text is working fine.

Thanks

Do you mean first give the extention as .csv in output and then open using excel?