Exemplos de SampleSqlJobLibrary.Jobs SqlJobToSucceed.Execute em C# (CSharp)

Exemplo n.º 1

Arquivo: SqlJobBehavior.cs Projeto: kennethchoe/JobQueue

        public void SqlJobShouldExecuteSqlStatements()
        {
            var job = new SqlJobToSucceed();
            job.SetParameters(DateTime.Parse("1/1/2012"), "abcd", "TestLogs");
            job.Execute();

            var cmd = new SqlCommand("select top 1 LogText from TestLogs order by id desc", job.Connection);
            var returnValue = cmd.ExecuteScalar();
            returnValue.ShouldEqual("Macro parameter will be replaced anywhere. Inserting into TestLogs");
        }